Date&Time to legacy Date&Time

Options

Column selection

Only the included columns will be converted.

Time zone handling

The legacy Date&Time type does not support time zones. When converting values, you can choose how the time zone information should be handled:

• Add as offset: Uses the provided time zone to convert the value to a UTC-based timestamp.
  • Input: 2015-07-09T13:00:00+02:00[Europe/Berlin]
  • Output: 09.Jul.2015 15:00:00
• Drop: Removes any time zone information from the value.
  • Input: 2015-07-09T13:00:00+02:00[Europe/Berlin]
  • Output: 09.Jul.2015 13:00:00

Output columns

Whether to replace the original columns with the converted columns, or to append the converted columns with new names created by appending the specified suffix to the original column names.

• Replace: Replace each input column with the converted dates.
• Append with suffix: For each input column append a new column with the converted dates.

Suffix

Text appended to column names when new columns are created using the Append option.

Views

This node has no views

Workflows

• Boost your Passion for Sport! Analyze your sports data with KNIME+StravaKNIME Hub
• Date_TimeKNIME Forum
• kn_example_r_date_formats_extendedKNIME Hub
• KNIME_batchingV2KNIME Forum
• KNIME_batchingV2.5.knarKNIME Forum
• Show all 12 workflows

Links

• Date format changed to yyyy-mm-dd from dd-mm-yyyy when using “string to date/time” node?by armingrudd on 2019-05-15

  forum.knime.com/p/60538
• Current date formatby armingrudd on 2020-01-11

  forum.knime.com/p/78535
• Converting Dates during ETL proceduresby Andrew_Steel on 2019-10-05

  forum.knime.com/p/71755
• Issue with Send to Power BI Node Datesby armingrudd on 2020-03-07

  forum.knime.com/p/83659
• Checking csv file for ASCII Characters and getting java errorby izaychik63 on 2020-07-29

  forum.knime.com/p/98440

Developers