Hello Team,
My dates are showing up as minus one in comparison to the raw JSON, when I click on discover and search a record it shows up as 20210410 (see snippet attached) but when I check the raw JSON it is 20210411
Thanks and Regards,
Guru
Hello Team,
My dates are showing up as minus one in comparison to the raw JSON, when I click on discover and search a record it shows up as 20210410 (see snippet attached) but when I check the raw JSON it is 20210411
Thanks and Regards,
Guru
Can you look at the request made by kibana to ES and the answer when the date is not right? And then if you can, post it here, removing the sensitive data that you have. Are there timezones associated with the dates in ES? Are they the same timezone you're in?
In JSON documents, dates are represented as strings. Elasticsearch uses a set of preconfigured formats to recognize and parse these strings into a long value representing milliseconds-since-the-epoch in UTC.
Hope this helps
Rashmi
Hello @rashmi ,
Thanks for the response. I believe I have understood the issues. Currently my elastic time stamp is set to UTC and on Kibana side my time zone settings was US/Eastern so it was converting but I am trying to understand how can I set the time zone in elastic to EST instead of default UTC ?
Regards,
Guru
You can navigate to Stack Management> Advanced settings > Click on Timezone for date formatting
> you can change it to any timezone and save.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
© 2020. All Rights Reserved - Elasticsearch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.