Convert date-time to EPOCH
The Convert date-time to epoch mapping converts a date-time field in any format to a timestamp in seconds. The valid patterns are defined here: http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html This mapping converts the value from the conversion type to a timestamp in EPOCH.
The attributes that need to be set in this mapping are:
| Attribute | Required | Description |
|---|---|---|
| From | Y | Defines the field name before mapping. |
| To | Y | Defines the field name after mapping. |
| Precedence | N | Defines the precedence used when mapping. |
| Function type | Y | Defines the function type of mapping. Needs to be "String function". |
| Function | Y | Defines the type of mapping. Needs to be "Date conversion". |
| Conversion | Y | Defines the pattern of the incoming value. |
For example, to convert the value "24.07.2019 15:32:15", use the conversion "dd.MM.yyyy hh:mm:ss".