mysql - Sql-如何获取最近5分钟的数据

Question

您好，我正在尝试从数据库中提取最后 5 分钟的数据。我在下面编写的查询没有提取我需要的数据。

Select e.*
  from Event e
 where e.whenoccurred >= datefunc('10/01/2019 00:00 -05:00', '-5 minutes') 
   and dateadd(minutes,-5,getdate())  

我收到错误

Query has failed: no such column: minutes

有什么想法可以帮忙吗？

Answer 1

SysDate returns the current date and time set for the operating system on which the database resides. The datatype of the returned value is DATE, and the format returned depends on the value of the NLS_DATE_FORMAT initialization parameter. The function requires no arguments. In distributed SQL statements, this function returns the date and time set for the operating system of your local database.

此查询获取 sysdate 减去五分钟。

 select *
  from event
 where whenoccured >= sysdate - (5/1440)