按周分组统计 > select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tbl_name group by weeks; 按日分组统计 > select DATE_FORMAT(create_time,'%Y%m%d') days,count(caseid) count from tbl_name group by days; 按月分组统计 > select DATE_FORMAT(create_time,'%Y%m') months,count(caseid) count from tbl_name group by months;