Geek asks and answers

Get request 2 days ago in mysql

So, to get the last 24 hour request, I use something like this

SELECT COUNT(*) AS cnt FROM `mytable` WHERE timestamp >= DATE_SUB(NOW(), INTERVAL 1 DAY)

where timestampis the table field with timestamps.

but how can I get the interval between 2 days and yesterday. So

today is 24 years old. I want a request between 22 ian (00:00) and 23 ian (00:00)

+5
source share
4 answers
WHERE timestamp BETWEEN 
        DATE_SUB(DATE(NOW()), INTERVAL 2 DAY)
         AND DATE_SUB(DATE(NOW()), INTERVAL 1 DAY)
+18
source

You can also try DATE_ADDwith minus interval;)

WHERE timestamp BETWEEN 
        DATE_ADD(DATE(NOW()), INTERVAL -2 DAY)
         AND DATE_ADD(DATE(NOW()), INTERVAL -1 DAY)
+2
source

Use Interval

WHERE `timestamp`
    BETWEEN DATE_SUB(NOW(), INTERVAL 2 DAY)
    AND DATE_SUB(NOW(), INTERVAL 1 DAY)
+1
source

Try BETWEEN::

SELECT 
COUNT(*) AS cnt 

FROM `mytable` 

WHERE timestamp BETWEEN DATE_SUB(NOW(), INTERVAL 2 DAY) and DATE_SUB(NOW(), INTERVAL 1 DAY)
0
source

More articles:


All Articles