Index date starting with "Day of Week"

theonlyalterego · February 4, 2020, 8:58pm

Elastic Error:
Caused by: java.lang.IllegalArgumentException: failed to parse date field [Tue Feb 06 2029 00:00:00 GMT-0500 (Eastern Standard Time)] with format [yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss.SSS'Z'||yyyy/MM/dd HH:mm:ss||yyyy/MM/dd||epoch_millis]

Date input: Tue Feb 06 2029 00:00:00 GMT-0500 (Eastern Standard Time)

Is there a way I can match that format for a date in ES? I don't see any options in the format documentation for "day of week"

This is coming from a javascript date.toString() that I'd prefer not to have to change.

spinscale · February 5, 2020, 9:45am

Hey,

this would be a start to play around EEE MMM dd yyyy HH:mm:ss ZZZ - I am not sure if you can parse GMT-0500 and you also could try to play around with z as a pattern for (Eastern Standard Time).

You can play around at https://esddd.herokuapp.com/ with different date formats and see how those are parsed...

--Alex

system · March 4, 2020, 9:45am

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

Topic		Replies	Views
Date format parse error Elasticsearch	3	856	February 28, 2020
Date parsing issue - ElasticSearch 7.6 Elasticsearch	2	1001	May 26, 2020
Date format issue MMM D, YYYY h:mm:ss A Elasticsearch	4	3352	February 2, 2019
Formatting date format in ES index template Elasticsearch	1	607	April 22, 2020
Date format exception with elasticsearch version 6.7.0 Elasticsearch	1	464	July 1, 2020

Index date starting with "Day of Week"

Related topics