mssql dates returned incorrectly
Posted: Sun May 03, 2009 9:20 am
Code: Select all
$query = "SELECT hlc_ticket, convert(varchar, getdate(), 21) hlc_until FROM table WHERE (hlc_ticket LIKE '$prefix' ) AND (hlc_until >= '$date')";Thanks
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$query = "SELECT hlc_ticket, convert(varchar, getdate(), 21) hlc_until FROM table WHERE (hlc_ticket LIKE '$prefix' ) AND (hlc_until >= '$date')";