MySql获取某一天每个小时的数据

select hour(create_time) AS saleHour, count(id) AS saleCount

from tableName where date_format(create_time, ‘%Y-%m-%d’ ) = ‘2021-09-07’

group by hour(create_time)

select date_format(now(),'%d%H')

比如当前时间是2016-8-29 17:30

得到的结果就是 '2917'

有上面的结果就可以判定了,如查询今天下午5点的数据：

select column from table_name where date_format(createDate,'%d%H') = '2917'

如果需要加上年月日时分秒也是一样

date_format(now(),'%Y-%m-%d %h:%i:%s')

---