0 ×

Legacy Date&Time to Date&Time

StreamableKNIME Date and Time Handling version 4.4.0.v202106241857 by KNIME AG, Zurich, Switzerland

This node converts columns from the old Date&Time data type to the new types. 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.

New Type Selection

Automatic type detection
If checked, the type of the new column will be determined by the first row's content. If unchecked, you have to choose the new type manually.
New Type
The user can choose the new type. Available types are LocalDateTime , ZonedDateTime , LocalDate , and LocalTime . If ZonedDateTime is selected, a time zone can be chosen below (because the old type does not support time zones).

Time Zone Selection

Add time zone, if possible
If automatic type detection is enabled, you can choose whether a time zone should be added to cells which have date and time or not. To cells which have only date or time no time zone will be added.
Time Zone
If Add time zone is checked or ZonedDateTime is selected as new type, you can choose the time zone here.

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.

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.