0 ×

Date&Time to legacy Date&Time

StreamableKNIME Date and Time Handling version 4.2.1.v202007310802 by KNIME AG, Zurich, Switzerland

This node converts columns from the new Date&Time data types to the legacy type. It is only useful if you have to use nodes that have not been adapted to the new Date&Time type yet.


Column Selection

Column Selector
Only the included columns will be converted.

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.

Time Zone Handling

Add the offset of the time zone to the time

If the first option is selected, the offset of the time zone will be added to the time. Otherwise the time zone information will be dropped, because the legacy Date&Time type does not support time zones.

Output if first option is selected:
09.Jul.2015 15:00:00
Output if second option is selected:
09.Jul.2015 13:00:00

Input Ports

Input table

Output Ports

Output table containing the converted 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. Read our FAQs to get instructions about how to install nodes from a zipped update site.

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.


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.