The convert epoch to date-time is defined for value conversion in timestamps. The replacement string attribute in the mapping takes a pattern to construct a java.text.SimpleDateFormat object. The valid patterns are defined here: http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html
The attributes that need to be set in a time conversion 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 the mapping. Needs to be "Date function". |
Function | Y | Defines the type of mapping. Needs to be "date conversion". |
Replacement string | Y | Defines the time conversion. |
This mapping converts the timestamp from an EPOC type to the conversion defined in the Replacement String.
For example, the result of converting the timestamp 1578580241 to the format in the mapping is: 09-01-2020 09:57:21.