SELECT HOUR(e.user_scheduling_in_time) as Hour,count(*) as Count
FROM tb_user_scheduling e
WHERE e.user_scheduling_in_time between '2020-07-16 00:00:00' and '2020-07-16 23:59:59'
GROUP BY HOUR(e.user_scheduling_in_time) ORDER BY Hour(e.user_scheduling_in_time);
由上图可知查询正确。