Question

MySQL如何查询一个月每天某个时间段的数据？

字段：dInviteTime
数据格式：
2018-11-02 19:15:33
2018-11-02 19:19:30
2018-11-02 19:56:53
2018-11-03 07:24:28
2018-11-03 08:35:01
2018-11-03 08:56:48

如何查询一个月某个时间段的数据？
如
15:00-17:30
17:31-20:59

Answer 1

select date_format(atime,'%Y-%m-%d %H') as hour,count(*) as Count from z_alarm_false where atime >= '2019-1-25 00:00:00' and atime <= '2019-1-26 00:00:00' group by date_format(atime,'%Y-%m-%d %H');