# Canvas sql query for last 30 seconds
**URL:** https://discuss.elastic.co/t/canvas-sql-query-for-last-30-seconds/186102
**Category:** Kibana
**Created:** [June 17, 2019, 3:16pm UTC](https://discuss.elastic.co/t/canvas-sql-query-for-last-30-seconds/186102 "2019-06-17T15:16:37Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@u3432](https://discuss.elastic.co/u/u3432)
#### Post date: [June 17, 2019, 3:16pm UTC](https://discuss.elastic.co/t/canvas-sql-query-for-last-30-seconds/186102/1 "2019-06-17T15:16:37Z")
Hi all, I was wondering if its possible to do a sql query that limits to the last 30 seconds? So for example nginx access hits for last 30 seconds.
Thank You.
---
### Author:  [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)
#### Post date: [June 17, 2019, 5:18pm UTC](https://discuss.elastic.co/t/canvas-sql-query-for-last-30-seconds/186102/2 "2019-06-17T17:18:03Z")
`WHERE "@timestamp" > NOW() - INTERVAL 30 SECOND AND "@timestamp" <= NOW()`
---
### Author:  [@u3432](https://discuss.elastic.co/u/u3432)
#### Post date: [June 18, 2019, 7:59am UTC](https://discuss.elastic.co/t/canvas-sql-query-for-last-30-seconds/186102/3 "2019-06-18T07:59:25Z")
Thank you very much it works like a charm. This Elastic Stack system is incredible.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 16, 2019, 7:59am UTC](https://discuss.elastic.co/t/canvas-sql-query-for-last-30-seconds/186102/4 "2019-07-16T07:59:26Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.