Timezone in _sql query

Hi I use in my etl the _sql function to select some data from elastic. One simple example:
POST _sql?format=txt
{
"query": "select max("@timestamp"),monitor.id, monitor.ip, monitor.status from "heartbeat
" where "@timestamp" > now() - interval 10 minutes group by monitor.id, monitor.ip, monitor.status "
}*

The problem is that the @timestamp and other date fields are in UTC timezone, how can i specific in what timezone i want the result to be and what timezone is my date from where?

Hi @valerica_georgescu - Welcome to our community forums!

You may want to use the time_zone parameter and check if that addresses your requirements.

I hope that helps.

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.