SYSDATE 的时间范围

发布于 2024-12-04 18:38:45 字数 157 浏览 0 评论 0原文

我需要选择时间戳介于现在和过去 5 分钟之间的行。我该怎么做？就像这样：

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

越简单越好。

原文

I need to select rows where timestamp is between now and 5 minutes in the past. How do I do it? Something like that:

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

The simpler - the better.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

李白 2024-12-11 18:38:45

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

或旧样式：

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

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

or old style:

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

回复收藏 0 原文

硬不硬你别怂 2024-12-11 18:38:45

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') NOW
,           to_char(sysdate - 1/24/12,'yyyy-mm-dd hh24:mi:ss') "5 min. before"
    from dual;

NOW                 5 min. before
------------------- -------------------
2011-09-15 15:11:06 2011-09-15 15:06:06

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') NOW
,           to_char(sysdate - 1/24/12,'yyyy-mm-dd hh24:mi:ss') "5 min. before"
    from dual;

NOW                 5 min. before
------------------- -------------------
2011-09-15 15:11:06 2011-09-15 15:06:06

回复收藏 0 原文

~没有更多了~