Kibana converts any date and month to a specific date and month

Hi All, I am facing issues in date format. I have dates in '2021-05-03 23:11:25.84' format. If I create mapping like:

{
"format": "YYYY-MM-DD HH:mm:ss.SSS||YYYY-MM-DD HH:mm: ss.SS ||YYYY-MM-DD HH:mm:ss.S",
"type": "date"
}

I am getting dates in Kibana like Jan 4, 2021 @ 23:11:25.840. Can anyone please guide the right way to handle? Any date I store in elasticsearch Kibana changes that date to 1st Jan and keeps the year and time the same as I stored.

I have tried by changing:

  • Timezone for date formatting to UTC and US/Eastern
  • Date format to YYYY-MM-DD HH:mm:ss.SSS

Please suggest

It'd be helpful if you could provide an example of the data that you sending to Elasticsearch, and then the actual json document directly from Elasticsearch.

Hi @warkolm, Here are the screenshots:

Data I am sending to elasticsearch:

Mapping for the index:

The actual json document directly from Elasticsearch (using DevTools):

Kibana output:

As I noticed Month and date is being changed if the date contains time.

Please don't post pictures of text, they are difficult to read, impossible to search and replicate (if it's code), and some people may not be even able to see them :slight_smile:

If you can post that Dev tools json, I can try to replicate it as well.

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