Convert epoch to date-time
The "Convert epoch to date-time" function converts epoch timestamps into human-readable date and time formats. This conversion is essential for timestamp value transformations. The Replacement string attribute in the mapping specifies a pattern that constructs a java.text.SimpleDateFormat object. Valid patterns can be found by clicking here.
Attributes for Convert epoch to date-time mapping
| 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 epoch to date-time mapping". |
| Replacement string | Yes | Defines the pattern for time conversion using SimpleDateFormat. |
Usage Example
| Replacement string | Value Before mapping | Result After mapping |
|---|
| dd-MM-yyyy hh:mm:ss | 1578580241 | 09-01-2020 09:57:21 |