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?