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 | Yes | Defines the field name before mapping. |
| To | Yes | Defines the field name after mapping. |
| Precedence | Yes | Determines the order in which this mapping is applied relative to others. |
| Function type | Yes | Defines the function type of the mapping. Needs to be "Date function". |
| Function | Yes | Defines the type of mapping. Needs to be Convert date-time to epoch. |
| Conversion | Yes | 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.