Page 1 of 1

MSSQL

Posted: Sat Aug 22, 2009 4:53 am
by dejvos
Hello,

can someone tell me equivalent code for MSSQL:

Code: Select all

 
$query = "SELECT * FROM table WHERE mydatetime > '".date('Y-m-d H:i:s')."'";
 
Many thanks!

Re: MSSQL

Posted: Sun Aug 23, 2009 5:26 am
by dejvos
Ok,

I solved it:

Code: Select all

 
$query = " SELECT * FROM table WHERE date = CONVERT(datetime,".date('Y-m-d').")";