So for getting last 24 hours query I use something like this
SELECT COUNT(*) AS cnt FROM `mytable` WHERE timestamp >= DATE_SUB(NOW(), INTERVAL 1 DAY)
where timestamp
is a table field with timestamps.
but how can I get the interval between 2 days ago and yesterday. So
today is 24 ian. I want a query between 22 ian (00:00am) and 23 ian (00:00am)
See Question&Answers more detail:os