Mysql时间分组
按周 select DATE_FORMAT(create_time,%Y%u) weeks,count(caseid) count from tc_case group by weeks;
按月 select DATE_FORMAT(create_time,%Y%m) months,count(caseid) count from tc_case group by months;
按天 select DATE_FORMAT(create_time,%Y%m%d) days,count(ca…