- Store now() in a variable and then compare using where clause.
Also see this and this
Update :<?php
$timeZone="Asia/Kolkata"; //variable for indian timezone
date_default_timezone_set( $timeZone); //default timezone set to indian time
$now = date("m/d/y G.i:s");
echo $now;
?>
2
solved Select database where datetime>now()? [closed]