sql - SYSDATE 的时间范围

Question

我需要选择时间戳介于现在和过去 5 分钟之间的行。我该怎么做？类似的东西:

select * from tableName where timestamp between sysdate and up to -5 min

越简单越好。

Answer 1

select *
  from tableName
 where timestamp between sysdate and sysdate - interval '5' minute

或旧式:

select *
  from tableName
 where timestamp between sysdate and sysdate - 5 * 60 / 86400