Search for records with a date field in the last 24 hours

Question

In my SQL query, how can I find records in the last 24 hours? For example,

SELECT * FROM news WHERE date < 24 hours 

I usually do this by setting the date () variable to 1 day and comparing it with this, but I wondered if the sql query was faster?

Answer 1

You simply select dates that exceed the current time minus 1 day.

 SELECT * FROM news WHERE date >= now() - INTERVAL 1 DAY; 

Answer 2

 SELECT * FROM news WHERE date > DATE_SUB(NOW(), INTERVAL 24 HOUR) 

Answer 3

 SELECT * from new WHERE date < DATE_ADD(now(),interval -1 day); 

Answer 4

To get records in the last 24 hours:

 SELECT * from [table_name] WHERE date > (NOW() - INTERVAL 24 HOUR) 

Answer 5

 SELECT * FROM news WHERE date > DATEADD(d,-1,GETDATE()) 

Answer 6

There are so many ways to do this. The above works fine, but here is another way if you have a datetime field:

 SELECT [fields] FROM [table] WHERE timediff(now(), my_datetime_field) < '24:00:00' 

timediff() returns a time object, so don't make a mistake comparing it to 86400 (number of seconds per day), or your result will be all kinds of.

Answer 7

 SELECT * FROM news WHERE date < DATEADD(Day, -1, date)