[thelist] CF & MySQL: Date/Time operations

Minh Lee Goon evolt at goonies.info
Tue Jul 18 16:09:40 CDT 2006

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