xiaoer1345980的博客

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%d’) days,count(caseid) count from tc_case group by days; select DATE_FORMAT(create_time,’%Y%m’)