Modify Date

Modifies date&time columns in three different ways. The node can append a date to local time columns (output type is local or zoned date time column) or change the date in local or zoned date&time columns or remove the date from local or zoned date&time columns (output type is local time).
This node is not used to add ("plus") or subtract ("minus") date. 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.

Date Selection

Append Date

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

Change Date

Changes the date 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 Date

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

Date

A date value in form of yyyy-MM-dd.

Time Zone

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

Views

This node has no views

Workflows

• 01_DateTime_ManipulationKNIME Hub
• 01_DateTime_Manipulation - SolutionKNIME Hub
• 01_DateTime_Manipulation - SolutionKNIME Hub
• 06_Manipulating_Date_and_Time_ValuesKNIME Hub
• 06_Manipulating_Date_and_Time_ValuesKNIME Hub
• 10_DateTime_Manipulation - SolutionKNIME Hub
• KNIME_project23KNIME Forum
• LI_Data_AppKNIME Hub
• Linkedin Data AppKNIME Hub
• Manipulating timestamp to separate date and timeKNIME Forum
• TopicKRKNIME Hub

Links

• No links available

Developers