mysql统计语句

查询今日数据
select * from t_time where TO_DAYS(NOW()) - to_days(time) <1
查询昨日数据
SELECT * FROM t_time WHERE TO_DAYS( NOW( ) ) - TO_DAYS( time) =1
查询近七天数据
SELECT * FROM t_time where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(time)
查询近三十天数据
SELECT * FROM t_time where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(time)
查询时间段内的数据
SELECT * FROM t_time where DATE_FORMAT(create_time, ‘%Y-%m-%d’)
BETWEEN
#{startDate,jdbcType=VARCHAR} AND #{endDate,jdbcType=VARCHAR}