查询今日数量:
select count(1) from task where TO_DAYS(create_time) = TO_DAYS(NOW())
查询近七天数量:
select count(1) from task where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(create_time)
查询近一个月数量:
SELECT count(1) FROM task where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)
查询近一年数量:
SELECT count(1) FROM task where YEAR(create_time)=YEAR(NOW())