# Time\_zone in sql query

**URL:** <https://discuss.elastic.co/t/time-zone-in-sql-query/371471>\
**Category:** Elasticsearch\
**Created:** [December 4, 2024, 2:59pm UTC](https://discuss.elastic.co/t/time-zone-in-sql-query/371471 "2024-12-04T14:59:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [December 4, 2024, 2:59pm UTC](https://discuss.elastic.co/t/time-zone-in-sql-query/371471/1 "2024-12-04T14:59:41Z")

</div>

I have metricbeat time series data. time field is @timestamp

due to BST and UTC time difference of one hour I can't get data

```auto
GET _sql?format=txt
{
  "query": """
        select host.name as host, 
        from "my-metricbeat-*"  
        where "@timestamp" > now() - interval '1' minute 
""" 
}

```

I get zero result. but if I do 60+ min I get data. How do I add time\_zone in this query to retrieve data?

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [December 4, 2024, 10:02pm UTC](https://discuss.elastic.co/t/time-zone-in-sql-query/371471/2 "2024-12-04T22:02:47Z")

</div>

I have figure out this is how you do it.

`"@timestamp" > DATE_ADD('hour', -1,now()) - interval '1' minute`