摘要: 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, 阅读全文
posted @ 2012-08-24 10:31 MrRock 阅读(726) 评论(0) 推荐(0) 编辑