ES 7.3 --- date_time_parse_exception: Text '2020-08-25 11:50:00 AM'

Hi All,
I am getting following error message
"failed to parse date field [2020-08-25 11:50:00 AM] with format [uuuu-MM-dd HH:mm:ss:SSS||uuuu-MM-dd HH:mm a||uuuu-MM-dd HH:mm:ss||uuuu-MM-dd HH:mm:ss a||uuuu-MM-dd||epoch_millis||MM-dd-uuuu]: [Text '2020-08-25 11:50:00 AM' could not be parsed, unparsed text found at index 19]"
when running query on ES index. I am not figure it out that when i am providing specific format for date type and passing value as per format than why i am getting this issue.

ES Version: 7.3
Index Mapping:
PUT temp_duty
"mappings" : {
"properties" : {
"order_date_time" :
{"type":"date","format":"uuuu-MM-dd HH:mm:ss:SSS||uuuu-MM-dd HH:mm a||uuuu-MM-dd HH:mm:ss a||uuuu-MM-d HH:mm:ss||epoch_millis||uuuu-MM-dd||MM-dd-uuuu"}
Note:- i also tried with following mapping as well
"type":"date","format":"yyyy-MM-dd HH:mm:ss:SSS||yyyy-MM-dd HH:mm a||yyyy-MM-dd HH:mm:ss a||yyyy-MM-d HH:mm:ss||epoch_millis||yyyy-MM-dd||MM-dd-yyyy"}

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