摘要：selectDATE_FORMAT(create_time,'%Y%u')weeks,count(caseid)countfromtc_casegroupbyweeks; selectDATE_FORMAT(create_time,'%Y%m%d')days,count(caseid)countfromtc_casegroupbydays; selectDATE_FORMAT(create_time,'%Y%m')months,count(caseid)countfromtc_casegroupbymonths;DATE_FORMAT(date, 阅读全文