Alex, Sorry I don't understand. I presume you meant dateadd and not date_add?
Will "Sicular, Alexander" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED] du>... > Will, > > DATE_ADD(TheDate, INTERVAL -1440 MINUTE) > > Gl, > alex W Luke <mailto:[EMAIL PROTECTED]> said on Sunday, June 01, 2003 7:55 AM: > 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
