You could also play around with DATE_ADD/SUB, for example:
SELECT DATE_SUB(NOW(), INTERVAL 24 HOUR) AS 24_hours_ago;