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"}