elasticsearch-sql

Question

如图，请问elasticsearch-sql语句如何查询300分钟之前到当前时间之间的数据

Answer 1

这样呢

select * from security_warn_one  where warningtime  between  date_sub(now(), Interval 300 minute) and now()