Convert date [string] to an ElasticSearch date field?

asked 2019-06-17 13:50:33 -0500

daveh gravatar image

updated 2019-06-17 13:51:11 -0500

Using the Elasticsearch 5.2.0 stage, with a /datetime field formated as 'yyyy-MM-dd HH:mm:ss.SSSZ', I'm trying to convert the /datetime field to an ElasticSearch date field so that I can have Kibana use that as the @timestamp field.

However, using the Field Converter and selecting either the DATETIME/DATE/TIME conversion, SDC sends the converted field as an epoch number which ES recognizes as a number rather than a date/time field

How can have the ElasticSearch stage send a datetime field to ES?

Thanks in advance.

edit retag flag offensive close merge delete


What format is ES expecting for its date fields?

metadaddy gravatar imagemetadaddy ( 2019-06-17 14:06:37 -0500 )edit