[thelist] CF & MySQL: Date/Time operations

Chris Hayes chris at lwcdial.net
Tue Jul 18 16:14:30 CDT 2006

Not sure about MySQL but MSSQL's date format uses a string syntax...so you 
might try



----- Original Message ----- 
From: "Minh Lee Goon" <evolt at goonies.info>
Subject: [thelist] CF & MySQL: Date/Time operations

>I have this simple query that doesn't work in MySQL, but it does with
> Access. Any ideas on how I can get it running again? Thanks.
> FROM   Interview
> WHERE  Interview_Date < #CreateODBCDate(Now())#
> ORDER BY Interview_Date DESC

More information about the thelist mailing list