在MySQL中获取2天前的查询 [英] get 2 days ago query in mysql

问题描述

为了获得最近24小时的查询，我使用了类似的方法

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)

其中timestamp是带有时间戳的表字段.

where timestamp is a table field with timestamps.

但是如何获取2天前和昨天之间的间隔. 所以

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

今天是24 ian.我想在22 ian(00:00 am)和23 ian(00:00 am)之间进行查询

today is 24 ian. I want a query between 22 ian (00:00am) and 23 ian (00:00am)

推荐答案

WHERE timestamp BETWEEN 
        DATE_SUB(DATE(NOW()), INTERVAL 2 DAY)
         AND DATE_SUB(DATE(NOW()), INTERVAL 1 DAY) 

这篇关于在MySQL中获取2天前的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！