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 and date is between Oct 15, 2022 @ 00:00:00.000 - Oct 16, 2022 @ 00:00:00.000

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

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.

1 Like

this a problem when I am writing a backend serive to run queries to elaticsearch,what is your solution?

Why is it a problem? There is no away around the fact that all timestamps are in UTC in Elasticsearch.

thanx so much.

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