Date&Time to legacy 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.

Time Zone Handling

Add the offset of the time zone to the time

If the first option is selected, the offset of the time zone will be added to the time. Otherwise the time zone information will be dropped, because the legacy Date&Time type does not support time zones.

Example:
Input:
2015-07-09T13:00:00+02:00[Europe/Berlin]
Output if first option is selected:
09.Jul.2015 15:00:00
Output if second option is selected:
09.Jul.2015 13:00:00

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