# Essql timestamp query in canvas **URL:** \ **Category:** Kibana\ **Tags:** elastic-stack-sql, canvas\ **Created:** [July 2, 2020, 9:29pm UTC](https://discuss.elastic.co/t/essql-timestamp-query-in-canvas/239712 "2020-07-02T21:29:05Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [July 2, 2020, 9:29pm UTC](https://discuss.elastic.co/t/essql-timestamp-query-in-canvas/239712/1 "2020-07-02T21:29:05Z")
SELECT islandtype FROM "index1\*" where '@timestamp' \> now() - INTERVAL 200 minutes group by islandtype this give me blank it says no document found. but I know I have document. when I remove where clause it give me output. what am I doing wrong? this in canvas ---
**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\ **Post date:** [July 3, 2020, 8:12am UTC](https://discuss.elastic.co/t/essql-timestamp-query-in-canvas/239712/2 "2020-07-03T08:12:21Z")
You have to use double quotes to escape the field name: `"@timestamp"`. Otherwise it will compare it with the literal string `@timestamp` ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [July 3, 2020, 4:57pm UTC](https://discuss.elastic.co/t/essql-timestamp-query-in-canvas/239712/3 "2020-07-03T16:57:30Z")
that worked. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 31, 2020, 4:57pm UTC](https://discuss.elastic.co/t/essql-timestamp-query-in-canvas/239712/4 "2020-07-31T16:57:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.