[thelist] CF & MySQL: Date/Time operations

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

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

More information about the thelist mailing list