UNIX Timestamp to Date&Time

Parses the integer or long values in the selected columns and converts them into date&time cells. The inputs should be unix timestamps either in seconds, milli-, micro- or nanoseconds since the epoch (1.1.1970).
For the output you may choose between local and zoned date and time formats and if necessary add the timezone.

Options

Timestamp columns

The columns to convert to date&time columns.

Timestamp granularity

The unit of the input unix timestamp.

Output type

Select the type of the new columns.

• Date: Outputs values of type Date
• Time: Outputs values of type Time
• Date & time: Outputs values of type Date&time (Local)
• Date & time & zone: Outputs values of type Date&time (Zoned)

Timezone

Select the timezone of the new columns.

Output columns

Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.

• Replace: Replaces the selected columns by the new columns.
• Append with suffix: Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.

Output column suffix

The suffix to append to the column names of the new columns.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers