# Elasticsearch query with timezone conversion **URL:** \ **Category:** Elasticsearch\ **Created:** [January 15, 2020, 10:13pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220 "2020-01-15T22:13:27Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [January 15, 2020, 10:13pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/1 "2020-01-15T22:13:27Z")
I have put a record in elk input message =\> '{"submitted\_date": "2020-01-14 10:05:11.11"}' it got saved as UTC, 8 hour earlier (Singapore timezone) ``` { "submitted_date" => 2020-01-14T02:05:11.110Z } ``` in kibana dev tool when I run search I get this, which is correct. ``` GET /sachin_quick_test/_search { "submitted_date" : "2020-01-14T02:05:11.110Z" } ``` Now I want this to display 8 hour+ but it still displays same. how do I fix this? am I using wrong parameter? ``` GET /sachin_quick_test/_search { "query": { "range" : { "submitted_date": { "gte": "2020-01-13", "lte": "2020-01-15", "time_zone": "+08:00" } } } } ``` ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [January 15, 2020, 10:40pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/2 "2020-01-15T22:40:05Z")
running version 7.5.0 ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [January 16, 2020, 1:59pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/3 "2020-01-16T13:59:37Z")
Anyone? ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [January 16, 2020, 5:44pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/4 "2020-01-16T17:44:03Z")
Anything I can do to move time + or - ? I see bunch of people has same question same query listed in elastic documents. why is it not working? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [January 16, 2020, 5:57pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/5 "2020-01-16T17:57:56Z")
Read [this](https://discuss.elastic.co/t/about-the-elasticsearch-category/21) and specifically the "Also be patient" part. It's fine to answer on your own thread after 2 or 3 days (not including weekends) if you don't have an answer. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [January 16, 2020, 5:58pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/6 "2020-01-16T17:58:58Z")
> [@elasticforme](#): > > how do I fix this? If I understood correctly. What about giving the right timezone at index time? ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [January 16, 2020, 6:11pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/7 "2020-01-16T18:11:01Z")
> [@elasticforme](#): > > 8 hour earlier ( if I save with right timezone then result in kibana is off. We want to let elasticsearch and kibana handle their thing. As all of you mentions in other posts. and retrieve data using time\_zone because very few people are going to retrieve data using query we have different data from CST/GMT/SGT and many more timezone. if we convert it while ingestion we will have to change timezone in kibana setting for everyone as well. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [January 16, 2020, 10:41pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/8 "2020-01-16T22:41:04Z")
So you want to ingest data as GMT based and see the data with the GMT time from everywhere in the world? If you index something which time is 1AM, you want to see this value 1AM even if you're not in the GMT timezone. Did I understand ? ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [January 17, 2020, 2:19pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/9 "2020-01-17T14:19:16Z")
Sorry I am not able to make it clear. let me try again. I want date field ingested and converted by Elasticsearch and Kibana as it should be doing by default ( that is convert everything to UTC, and display back on kibana with broweser time) above is working as it is design by ELK But currently when I go to dev tool and run query date is in UTC. Where I would like to convert to whatever timezone I define in query which is not working. For example - This is default ``` GET /sachin_quick_test/_search { "query": { "range" : { "submitted_date": { "gte": "2020-01-13T00:00:00" } } } } ``` Output looks like this "submitted\_date" : "2020-01-14T02:05:11.110Z", But I want to be display at 10:05:11.11 ( as Perth time SGT, +8 hour, as I am defining time\_zone ) ``` GET /sachin_quick_test/_search { "query": { "range" : { "submitted_date": { "time_zone": "+08:00", "gte": "2020-01-13T00:00:00", } } } } ``` But it still displays same no conversion happens. "submitted\_date" : "2020-01-14T02:05:11.110Z", ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [January 21, 2020, 6:02pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/10 "2020-01-21T18:02:39Z")
shouldn't it add 8 hour to existing time? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 10, 2020, 5:21pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/11 "2020-02-10T17:21:39Z")
Not when giving back the results. I mean that elasticsearch always gives you back the document as it has been indexed with no transformation. If this is what you mean. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 9, 2020, 5:21pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timezone-conversion/215220/12 "2020-03-09T17:21:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.