# Why elasticsearch search query (when you inspect)on date is different from kibana query on date? **URL:** \ **Category:** Elasticsearch\ **Tags:** kql-kibana-query-language\ **Created:** [January 8, 2023, 10:33am UTC](https://discuss.elastic.co/t/why-elasticsearch-search-query-when-you-inspect-on-date-is-different-from-kibana-query-on-date/322676 "2023-01-08T10:33:36Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![alex\_petrov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_petrov/32/105688_2.png) [@alex\_petrov](https://discuss.elastic.co/u/alex_petrov)\ **Post date:** [January 8, 2023, 10:33am UTC](https://discuss.elastic.co/t/why-elasticsearch-search-query-when-you-inspect-on-date-is-different-from-kibana-query-on-date/322676/1 "2023-01-08T10:33:36Z")
I used date as a field in kibana as shown below and date is between Oct 15, 2022 @ 00:00:00.000 - Oct 16, 2022 @ 00:00:00.000 ![date2](https://us1.discourse-cdn.com/elastic/original/3X/c/4/c4ee8b3fd15f2e853f60246c17e6ef3edce21517.jpeg) why it is different from elasticsearch query when you inspect(as shown below)? ![time](https://us1.discourse-cdn.com/elastic/original/3X/6/8/68b794488f812c3cbbf4f4b891b681f88f43d1e0.jpeg) ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [January 8, 2023, 10:51am UTC](https://discuss.elastic.co/t/why-elasticsearch-search-query-when-you-inspect-on-date-is-different-from-kibana-query-on-date/322676/2 "2023-01-08T10:51:30Z")
In Elasticsearch all timestamps are stored in UTC timezone. Kibana by default translates timestamps into your local timezone. The interval you specified at the top is in your local timezone and this translates to the UTC timestamps shown in the query. ---
**Author:** ![alex\_petrov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_petrov/32/105688_2.png) [@alex\_petrov](https://discuss.elastic.co/u/alex_petrov)\ **Post date:** [January 8, 2023, 11:17am UTC](https://discuss.elastic.co/t/why-elasticsearch-search-query-when-you-inspect-on-date-is-different-from-kibana-query-on-date/322676/3 "2023-01-08T11:17:40Z")
this a problem when I am writing a backend serive to run queries to elaticsearch,what is your solution? ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [January 8, 2023, 11:21am UTC](https://discuss.elastic.co/t/why-elasticsearch-search-query-when-you-inspect-on-date-is-different-from-kibana-query-on-date/322676/4 "2023-01-08T11:21:29Z")
Why is it a problem? There is no away around the fact that all timestamps are in UTC in Elasticsearch. ---
**Author:** ![alex\_petrov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_petrov/32/105688_2.png) [@alex\_petrov](https://discuss.elastic.co/u/alex_petrov)\ **Post date:** [January 8, 2023, 11:23am UTC](https://discuss.elastic.co/t/why-elasticsearch-search-query-when-you-inspect-on-date-is-different-from-kibana-query-on-date/322676/5 "2023-01-08T11:23:27Z")
thanx so much. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 5, 2023, 11:23am UTC](https://discuss.elastic.co/t/why-elasticsearch-search-query-when-you-inspect-on-date-is-different-from-kibana-query-on-date/322676/6 "2023-02-05T11:23:36Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.