[thelist] CF & MySQL: Date/Time operations

[Chris Hayes]

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

'#CreateODBCDate(Now())#'

HTW


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