Mysql查询每天 每周 每月 每年的数据

-- 查询每天的数据
SELECT COUNT(1) as total,DATE_FORMAT(create_time,'%Y-%m-%d') as time FROM op_endor_info GROUP BY DATE_FORMAT(create_time,'%Y-%m-%d');

-- 查询每周的数据
SELECT COUNT(1) as total,WEEK(create_time) as time FROM op_endor_info GROUP BY WEEK(create_time);

-- 查询每月的数据
SELECT COUNT(1) as total,MONTH(create_time) as time FROM op_endor_info GROUP BY MONTH(create_time);

-- 查询每年的数据
SELECT COUNT(1) as total,YEAR(create_time) as time FROM op_endor_info GROUP BY YEAR(create_time);

-- 其他：
-- DATE_ADD(,INTERVAL expr unit)
-- DATE_ADD(create_time,INTERVAL 1 DAY)  得到指定日期后一天的日期/把1改为任意数字就可以得到后n天的日期
-- DATE_SUB(,INTERVAL expr unit)
-- DATE_SUB(create_time,INTERVAL 1 DAY)  得到指定日期前一天的日期/把1改为任意数字就可以得到前n天的日期