Modify Time

Modifies date&time columns in three different ways. The node can append a time to local date columns (output type is local or zoned date time column) or change the time in local or zoned date&time columns or remove the time from local or zoned date&time columns (output type is local date).
This node is not used to add ("plus") or subtract ("minus") time. Use the Date&Time Shift node for that.

Options

Column Selection

Column Selector

Only the included columns will be modified.

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 new columns.

Time Selection

Append Time

Appends a time to local date columns. Optionally a time zone can be appended too.

Change Time

Changes the time of local or zoned date&time columns. The time zone will not be changed. The Modify Time Zone node can be used to change it.

Remove Time

Removes the time from local or zoned date&time columns. Time zones will be removed too.

Time

A time value in form of HH:mm:ss or HH:mm:ss.SSS. For example 12:10:30.123 means 12 hours, 10 minutes, 30 seconds, 123 milliseconds .

Time Zone

If checked, the user can choose a time zone to append also.

Views

This node has no views

Workflows

• 00_Progress_Tracker_Supply_Logistics_ExampleKNIME Hub
• 00_Progress_Tracker_Supply_Logistics_ExampleKNIME Hub
• 00_売上集計レポート・アプリKNIME Hub
• 01 Data and Time and DatabasesKNIME Hub
• 01 Date and Time and DatabasesKNIME Hub
• Show all 361 workflows

Links

• Checking csv file for ASCII Characters and getting java errorby izaychik63 on 2020-07-29

  forum.knime.com/p/98440

Developers