//分组条件的左截取,另命名dd分组,按时间排序;#{beginTime} AND #{endTime}mybatis的写法,开始时间和截止时间 select left(video_play_time, 10) as dd, sum(video_play_time_long) AS videoPlayTimeLong from t_video_play_record where video_play_time between #{beginTime} AND #{endTime} Group by dd order by video_play_time