Legacy Date&Time to Date&Time

Options

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.

Views

This node has no views

Workflows

• 01 Taxi Demand Prediction on Spark TrainingKNIME Hub
• 02 Taxi Demand Prediction on Spark DeploymentKNIME Hub
• Adding missing values based on previous row valueKNIME Forum
• Adding missing values based on previous row value - with contiguous missing valuesKNIME Forum
• Archive old records from CSV filesKNIME Forum
• Show all 52 workflows

Links

• can’t convert string in date timeby armingrudd on 2020-01-20

  forum.knime.com/p/79260
• Date Time Calculation helpby quaeler on 2020-06-12

  forum.knime.com/p/94208

Developers