0 ×

UNIX Timestamp to Date&Time

StreamableKNIME Date and Time Handling version 4.3.0.v202012011138 by KNIME AG, Zurich, Switzerland

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.


Column Selection

Column Selector
Only the included columns will be parsed.

Replace/Append Selection

Append selected columns
The selected columns will be appended to the input table. The suffix of the appended columns can be provided in the text field to the right.
Replace selected columns
The selected columns will be replaced by the converted columns.

Input Format

Input unit
The unit of the input unix timestamp. May be either milli-, micro- or nanoseconds.

Output Format

New type
The type of the new data cells can be selected.
A timezone with an optional offset, e.g. 'UTC', 'GMT+2' or 'CET-1'. Is only used if 'Zoned Date&Time' is selected as the New Type.

Input Ports

Input table.

Output Ports

Output table containing the parsed columns.

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Base nodes from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.