How to select records from last 24 hours using SQL?

Question

What where clause should be use to get records from the last 24 hours?

Answer 1

select ...
from ...
where YourDateColumn >= getdate()-1

Answer 2

select * from table_name where date_col > sysdate-1; //Oracle
select * from table_name where date_col > now()-1; //Mysql

Answer 3

In MySQL:

SELECT  *
FROM    mytable
WHERE   record_date >= SYSDATE() - INTERVAL 1 DAY

In SQL Server:

SELECT  *
FROM    mytable
WHERE   record_date >= DATEADD(day, -1, GETDATE())

In Oracle:

SELECT  *
FROM    mytable
WHERE   record_date >= SYSDATE - 1

In PostgreSQL:

SELECT  *
FROM    mytable
WHERE   record_date >= NOW() - '1 day'::INTERVAL

Answer 4

SELECT * 
FROM tableName 
WHERE datecolumn >= dateadd(hour,-24,getdate())

Answer 5

Which SQL was not specified, SQL 2005 / 2008

SELECT yourfields from yourTable WHERE yourfieldWithDate > dateadd(dd,-1,getdate())

If you are on the 2008 increased accuracy date types, then use the new sysdatetime() function instead, equally if using UTC times internally swap to the UTC calls.

Answer 6

SELECT * 
FROM table_name
WHERE table_name.the_date > DATE_SUB(CURDATE(), INTERVAL 1 DAY)