datetime question 1

[foxphpbomb]

I have to sort a result by a datetime field so that it will show records for the past 24 hours and also for the past 7 days. I need 2 modified sql queries of the one below.

select * from table ORDER by datettimefield DESC

 

[r937]

select * from table 
WHERE datetimefield >= date_sub(current_datetime, interval 24 hour)
ORDER by datettimefield DESC

select * from table 
WHERE datetimefield >= date_sub(current_date, interval 7 day)
ORDER by datettimefield DESC

notice the subtle difference in the second one

r937.com | rudy.ca