在PostgreSQL中，查询30分钟前的数据的SQL怎样写？时间字段为Time

南蛮

如题

zzzmafa

select * from tableName
where (TimeName + '30 minutes'::INTERVAL) < now()

yueliangdao0608

t_girl=# select * from a;
id | name  |  real_test  |         real_time         
----+-------+-------------+----------------------------
  1 | 11111 | 12345678.45 | 2008-03-21 12:30:56.967473
  2 | 22222 | 12345678.45 | 2008-03-21 12:30:56.967473
  3 | 33333 | 12345678.45 | 2008-03-21 12:30:56.967473
    | 4444  |    15222.02 | 2008-03-21 13:01:42.290211
(4 rows)














t_girl=# select * from a where real_time <= (timestamp 'now' - interval '30 minutes');
id | name  |  real_test  |         real_time         
----+-------+-------------+----------------------------
  1 | 11111 | 12345678.45 | 2008-03-21 12:30:56.967473
  2 | 22222 | 12345678.45 | 2008-03-21 12:30:56.967473
  3 | 33333 | 12345678.45 | 2008-03-21 12:30:56.967473
(3 rows)