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;
sel
create_time时间格式
SELECT DATE_FORMAT(create_time,"%Y%u") weeks,COUNT(id) COUNT FROM role GROUP BY weeks;
SELECT DATE_FORMAT(create_time,"%Y%m%d") days,COUNT(id) COUNT FROM role GR
