[thelist] CF & MySQL: Date/Time operations

[Minh Lee Goon]

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.

SELECT *
FROM   Interview
WHERE  Interview_Date < #CreateODBCDate(Now())#
ORDER BY Interview_Date DESC