select DATE_FORMAT(create_date,'%Y%u') weeks,count(event_id) count from t_alarm_event where create_date > '2015-10-22' and (event_type = 12 or event_type=13) group by weeks;
select DATE_FORMAT(create_date,'%Y%m%d') days,count(event_id) count from t_alarm_event where create_date > '2015-10-22' and (event_type = 12 or event_type=13) group by days;
select DATE_FORMAT(create_date,'%Y%m') months,count(event_id) count from t_alarm_event where create_date > '2015-10-22' and (event_type = 12 or event_type=13) group by months;
MySQL按周、按日和按月分组统计数据
最新推荐文章于 2022-07-18 13:16:53 发布