MySQL, Coldfusion, Selecting records that were timestamped in the last 24 hours.
Posted
by nobosh
on Stack Overflow
See other posts from Stack Overflow
or by nobosh
Published on 2010-05-09T02:55:01Z
Indexed on
2010/05/09
2:58 UTC
Read the original article
Hit count: 245
With Coldfuson & MySQL - How to update the query to check for new entries that have a timestamp that occurs in the last 24 hours?
Query:
<cfquery name="caller.sel_BlogEntries" datasource="#request.db#">
SELECT blogentry.dateAdded, person.personName
FROM blogentry INNER JOIN person ON blogentry.personID = person.personID
WHERE blogentry.deleted = 'N'
ORDER BY blogentry.dateAdded DESC
</cfquery>
blogentry.dateAdded is a MySql TimeStamp
Thanks
© Stack Overflow or respective owner
