mysql 获取某月所有上午的数据

    (SELECT *,count(1),SUM(if(ARRIVE.ARRIVE_TIME != '无',1,0)) as s  FROM  lt_cleanroute_point_arrive AS ARRIVE  
            WHERE DATE_FORMAT(data_dt,'%Y-%m') = '2022-12' and TIME(data_dt) BETWEEN '00:00:00' AND '12:00:00'  GROUP BY NAME ) 

关键代：

TIME(data_dt) BETWEEN '00:00:00' AND '12:00:00'