-
MySql获取某一天每个小时的数据
select hour(create_time) AS saleHour, count(id) AS saleCount from tableName where date_format(create_time, ‘%Y-%m-%d’
select hour(create_time) AS saleHour, count(id) AS saleCount from tableName where date_format(create_time, ‘%Y-%m-%d’