Php – querying results from thesql in the last 3 hours

datetime, mysql, php

i want to query blog posts from the database created in the last 3 hours,

table

blogs{id,blog_text,date}

date format: datetime

Best Solution

Try this:

SELECT * FROM blogs WHERE date > DATE_ADD(NOW(), INTERVAL -3 HOUR)

Edit: my bad - replaced CURDATE() with NOW() as we're dealing with DateTimes.