Converty query result's datetime accroding to timezone in Elasticsearch


(Ashish Tiwari) #1

I have situation, I am having field "time" with format "2018-07-12:00:00". I am hitting below query according to timezone:

curl -X GET "localhost:9200/myindex/_search" -H 'Content-Type: application/json' -d'
{
"query": {
    "range" : {
        "atime" : {
             "gte" : "2018-07-11 22:28:24",
             "lte" : "2018-06-13 12:00:00",
		     "time_zone": "+01:00"
        }
    }
}
}'

Its giving me proper output with below field:
time : 2018-06-13 12:00:00

How i can convert my time field according to timezone (i.e 2018-06-13 13:00:00) in my result set?

Is there any option in elasticsearch like convert_tz (mysql)


(system) #2

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