[thelist] CF & MySQL: Date/Time operations

[Ken Moore]

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.
>
>SELECT *
>FROM   Interview
>WHERE  Interview_Date < #CreateODBCDate(Now())#
>ORDER BY Interview_Date DESC

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

Ken

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/