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 Time Conversion Mapping
| 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 the mapping. Needs to be "Date function". |
| Function | Y | Defines the type of mapping. Needs to be "date conversion". |
| Replacement string | Y | 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 |