Find records with a date field in the last 24 hours

Question

In my SQL query how do i make it find the records in the last 24 hours  Eg     SELECT   FROM news WHERE date  lt  24 hours   I usually do it by setting a variable to date   - 1 day and comparing it to that but I wondered whether the sql query way was faster

User · Answer

SELECT   FROM news WHERE date  gt  DATE SUB NOW    INTERVAL 24 HOUR

User · Answer

You simply select dates that are higher than the current time minus 1 day   SELECT   FROM news WHERE date  gt   now   - INTERVAL 1 DAY

User · Answer

SELECT   FROM news WHERE date  lt  DATEADD Day  -1  date

User · Answer

There are so many ways to do this  The listed ones work great  but here s another way if you have a datetime field   SELECT  fields   FROM  table   WHERE timediff now    my datetime field   lt   24 00 00    timediff   returns a time object  so don t make the mistake of comparing it to 86400  number of seconds in a day   or your output will be all kinds of wrong

User · Answer

SELECT   from new WHERE date  lt  DATE ADD now   interval -1 day

User · Answer

To get records from the last 24 hours   SELECT   from  table name  WHERE date  gt   NOW   - INTERVAL 24 HOUR

User · Answer

SELECT   FROM news WHERE date  gt  DATEADD d -1 GETDATE

[mysql] Find records with a date field in the last 24 hours

Examples related to mysql

Examples related to sql

Examples related to date