查找出最近7天的数据
select * from 表名
where time
between (select current_timestamp - interval '3 day')and current_timestamp;
查找出最近7天的数据
select * from 表名
where time
between (select current_timestamp - interval '3 day')and current_timestamp;