Records with date in the last 24 hours

Queries and Solutions › Category: MySQL › Records with date in the last 24 hours

0 Vote Up Vote Down

bestonetechnologies Staff asked 8 years ago

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

Question Tags: mysql

2 Answers

0 Vote Up Vote Down

akul answered 8 years ago

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

0 Vote Up Vote Down

Princy Malothra answered 8 years ago

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

Your Answer