(1) 基准时间为表中创建时间最早的数据,然后以这个时间为基准往前三天内或者七天内的最新数据
SELECT * from datetest WHERE day > (SELECT DATE_ADD(MAX(day),INTERVAL -7 DAY) FROM datetest) ORDER BY day DESC;
(2)以当前时间为基准
SELECT * from datetest WHERE day > DATE_ADD(NOW(),INTERVAL -7 DAY) ORDER BY day DESC