数据按年、月、星期进行分组

SELECT SUM(times) AS month FROM day_records group by DATE_FORMAT(day_times,'%Y%m')    //按月进行分组

SELECT SUM(times) AS weeks FROM day_records group by DATE_FORMAT(day_times,'%Y%u')   //按星期进行分组

SELECT SUM(times) AS year FROM day_records group by DATE_FORMAT(day_times,'%Y')   //按年进行分组

daytime可以是时间戳，即datetime类型，也可以是数据库字段类型中的date类型