mysql 时间函数操作 week，month函数

1.按周查询

select WEEK(created,1),sum(message_num) from sms_report WHERE created BETWEEN '2019-12-01 08:00:00' AND '2019-12-31 08:00:00' group by WEEK(created,1)

week(时间)默认从0开始，星期天默认为第一天，及国外的算法

week(时间，1)从1开始，星期一为第一天，及国内算法

 

 

2.按月查询
select MONTH(created),sum(message_num) from sms_report WHERE created BETWEEN '2019-02-01 08:00:00' AND '2019-12-31 08:00:00' group by MONTH(created)