https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-convert-date-to-epoch-time-in-HCP-Grok-parser/m-p/202948#M78675 <P>Hi all, </P><P>I'm trying to add new telemetry of http-access log which have date format to HCP, but for the sensor to work i need to specify the timestampField on the sensor's JSON RAW which only recognize epoch format. </P><P>How can i convert the date format of log ( ex. 20/May/2017:12:19:39 +0700) to epoch format with grok parsher? </P><P>Thanks</P> Thu, 24 May 2018 11:10:47 GMT anggriawanrezab 2018-05-24T11:10:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-convert-date-to-epoch-time-in-HCP-Grok-parser/m-p/202948#M78675 <P>Hi all, </P><P>I'm trying to add new telemetry of http-access log which have date format to HCP, but for the sensor to work i need to specify the timestampField on the sensor's JSON RAW which only recognize epoch format. </P><P>How can i convert the date format of log ( ex. 20/May/2017:12:19:39 +0700) to epoch format with grok parsher? </P><P>Thanks</P> Thu, 24 May 2018 11:10:47 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-convert-date-to-epoch-time-in-HCP-Grok-parser/m-p/202948#M78675 anggriawanrezab 2018-05-24T11:10:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-convert-date-to-epoch-time-in-HCP-Grok-parser/m-p/202949#M78676 <P>Problem solved, i follow this <A href="https://metron.apache.org/current-book/metron-platform/metron-parsers/index.html">link</A>, and add this to the JSON Raw after "patternLabel":</P><PRE>"timestampField": "timestamp", "timeFields": ["timestamp"], "dateFormat": "dd/MMM/yyyy:HH:mm:ss Z"</PRE> Mon, 28 May 2018 11:42:18 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-convert-date-to-epoch-time-in-HCP-Grok-parser/m-p/202949#M78676 anggriawanrezab 2018-05-28T11:42:18Z