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
• Blanking repeated dataKNIME Forum
• Column Expressions ExampleKNIME Forum
• Column Name aggregation with Rule Engine (Multi Column}) componentKNIME Hub
• Company - Employee - DatesKNIME Forum
• Company - Employee - Dates - takbbKNIME Forum
• Convert question mark to missing valuesKNIME Hub
• Create tree from levelsKNIME Hub
• 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
• Equal apportionmentKNIME Hub
• Extract Data Table from Delimited TextKNIME Hub
• Find header row using a known list, from within data table and extract tableKNIME Hub
• Find previous date for documentKNIME Forum
• 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 Table SQL exampleKNIME Hub
• KNIME_projectKNIME Hub
• KNIME_project_1_Tarun_bhardwajKNIME Hub
• KNIME_project23KNIME Forum
• Lookup Bank SynonymsKNIME Hub
• Mat Det WizardKNIME Hub
• Match one of many amountsKNIME Hub
• Merge tablesKNIME Forum
• Modify strings to numbers based on formulaKNIME Hub
• Multiple flag columnsKNIME Forum
• Multiple Table RenamingKNIME Hub
• Partition Row SplitterKNIME Hub
• Populate one table from anotherKNIME Forum
• Progetto MLKNIME Hub
• Regex Multi Row SplitterKNIME Hub
• Replacement of missing values by typeKNIME Hub
• RSS Terms per Document Frequency Word CloudKNIME Hub
• Rule Engine (Multi Column)KNIME Hub
• SAS_DateTime_ConversionKNIME Forum
• Split tables into separate ports based on row partitioningKNIME Hub
• Standardising text for processing with Value Lookup and String CleanerKNIME 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