Time_zone in sql query

Elastic Stack Elasticsearch
1

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

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?

2

I have figure out this is how you do it.

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