can someone tell me equivalent code for MSSQL:
Code: Select all
$query = "SELECT * FROM table WHERE mydatetime > '".date('Y-m-d H:i:s')."'";
Moderator: General Moderators
Code: Select all
$query = "SELECT * FROM table WHERE mydatetime > '".date('Y-m-d H:i:s')."'";
Code: Select all
$query = " SELECT * FROM table WHERE date = CONVERT(datetime,".date('Y-m-d').")";