mysql 按月按周统计
http://hi.baidu.com/liangjian1024/blog/item/6861541b1416094842a9ad7c.html
表finance有俩个字段如下
date date
money double(15,2)
下面需要对表finance的2010年财务数据,按月进行统计
- select DATE_FORMAT(date,‘%Y-%m‘) as month,sum(money) as money
- from finance
- where DATE_FORMAT(date,‘%Y‘)=2010
- group by month
- order by month
下面是按周统计
查看MySQL的manual
%X Year for the week where Sunday is the first day of the week, numeric, four digits; used with %V
%x Year for the week, where Monday is the first day of the week, numeric, four digits; used with %v
其中
1如果周一为一周的第一天,则(小写) DATE_FORMAT(date,‘%x %v‘)
2如果周日为一周的第一天,则(大写) DATE_FORMAT(date,‘%X %V‘)
- select DATE_FORMAT(date,‘%x年-第%v周‘) as week,sum(money) as money
- from finance_base
- where DATE_FORMAT(date,‘%Y‘)=2010
- group by week
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。