[thelist] CF & MySQL: Date/Time operations

[Minh Lee Goon]

I should probably give you a little more information.

MySQL version is 4. This query is actually a query of another query. 
Would that make a difference in MySQL?



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
>