Search code examples
elasticsearchkibanaelastic-stack

Why elasticsearch search query (when you inspect)on date is different from kibana query on date?


I used date as a field in kibana as shown below to search documents and date is between Oct 15, 2022 @ 00:00:00.000 - Oct 16, 2022 @ 00:00:00.000 enter image description here

why it is different from elasticsearch query when you inspect(as shown below)? enter image description here


Solution

  • 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.