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

In my SQL query how do i make it find the records in the last 24 hours? Eg

   SELECT * FROM news WHERE date < 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?

You simply select dates that are higher than the current time minus 1 day.

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

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

To get records from the last 24 hours:

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

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

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