Darkmoon Darkmoon - 10 months ago 49
SQL Question

Fetch mysql inserted data from yesterday 14:00 till now

I am writing a php page and I want to fetch all rows inserted in mysql table from yesterday at 14:00 till current time, I tried many queries and functions in mysql but it didn't help, appreciate any help in this regard.



below is the right answer

WHERE updated_at >= concat(subdate(CURDATE(), 1),' 09:00:00')