Hi,
I used to use Access, and CreateODBCDateTime - and used the following to
grab all records created in the past day:
WHERE DATEDIFF ('n',TheDate,#CreateOdbcDatetime(DateAdd("n", -1440,
now() ) )# ) <= 1
Now that I'm on MySQL, I don't understand how createtime() works. The
field (TheDate) is DATETIME, and I would need to grab all records
created in the past 24 hours.
I also need similar queries, to find records submitted in the past 30
minutes and 60 minutes. Can anyone advise?
Sorry for all these questions.
Thanks
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
