Datetype format issue

Elastic Stack Elasticsearch
1

I have a date type field and I use default format. When index a field value like : 05/17/2018 01:37:48 PM ZE8, I got an error as below:

Invalid format: "05/17/2018 01:37:48 PM ZE8" is malformed at "/17/2018 01:37:48 PM ZE8"

I tried to use "yyyy-MM-dd HH:mm:ssZ||yyyy-MM-dd||epoch_millis" as the format, but it returned error like
Invalid format: "2018-05-17T05:37:48Z" is malformed at "T05:37:48Z"

Is there any suggestion which format can fix this ? Thx

2

I think that the default format expects something like day/month/year....

Here 17 can not be a month.

Have a look at this page: https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html#custom-date-formats

4

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