MySql按周,按月,按日分组统计数据
转载自http://linkyou.blog.51cto.com/1332494/751980/
知识关键词:DATE_FORMAT
select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks;
select DATE_FORMAT(create_time,'%
转载
2015-05-15 22:08:39 ·
802 阅读 ·
0 评论