Interview QuestionsCategory: MySQLRecords with date in the last 24 hours
bestonetechnologies Staff asked 9 months ago

How to select records with date in the last 24 hours?

2 Answers
akul answered 9 months ago

SELECT * FROM posts WHERE dateCreated > SUBDATE(CURDATE(), INTERVAL 24 HOUR);

Princy Malothra answered 9 months ago

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

Your Answer

4 + 3 =