[thelist] CF & MySQL: Date/Time operations
Hassan Schroeder
hassan at webtuitive.com
Tue Jul 18 16:39:30 CDT 2006
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.
If your CF function is just getting the current date, why not use
the native MySQL function and skip that CF call altogether?
> SELECT *
> FROM Interview
> WHERE Interview_Date < #CreateODBCDate(Now())#
WHERE Interview_Date < NOW()
> ORDER BY Interview_Date DESC
--
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
opinion: webtuitive.blogspot.com
dream. code.
More information about the thelist
mailing list