[thelist] CF & MySQL: Date/Time operations

Ken Moore psm2713 at hotmail.com
Tue Jul 18 16:19:06 CDT 2006

Hi all,

Minh Lee Goon wrote
>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

I cannot fine CreateODBCDate in the MYSQL documentation. What ar you looking 


Don’t just search. Find. Check out the new MSN Search! 

More information about the thelist mailing list