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
• Column Expressions ExampleKNIME Forum
• Creating additional rows based on time in existing rowsKNIME Forum
• Date_TimeKNIME Forum
• Delimited Text ReaderKNIME Hub
• Demo - dynamic database table creation with column size specificationKNIME Hub
• Demo - dynamic table creation with column size specificationKNIME Forum
• Extract Data Table from Delimited TextKNIME Hub
• Grouped Row SplittersKNIME Hub
• Identifying non-numeric strings using a Multi Column Rule EngineKNIME Hub
• Initial-Component in workflow bug in KAP 5.1 Modern UIKNIME Forum
• intersection of setsKNIME Forum
• Iteratively Processing Donations and ExpensesKNIME Forum
• Just Knime It Week2 v.1KNIME Hub
• KNIME_project_1_Tarun_bhardwajKNIME Hub
• KNIME_project23KNIME Forum
• Mat Det WizardKNIME Hub
• Merge tablesKNIME Forum
• Multiple Table RenamingKNIME Hub
• Populate one table from anotherKNIME Forum
• Progetto MLKNIME Hub
• Regex Multi Row SplitterKNIME Hub
• RSS Terms per Document Frequency Word CloudKNIME Hub
• Rule Engine (Multi Column)KNIME Hub
• SAS_DateTime_ConversionKNIME Forum
• Tabulating rows into columnsKNIME Forum
• Tabulating rows into columns with lag calculationKNIME Forum
• Taxi_VisualizationKNIME Hub
• test-real-life-edge-casesKNIME Hub

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