Hub
NodeNode / Manipulator

Modify Time

Other Data Types Time Series Manipulate Streamable
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table with modified time.

Extension

The Modify Time node is part of this extension:

Related workflows & nodes

  1. Date and Time and Databases - Exercise
    Date Time String to date&time
    +4
    This workflow shows a hands-on exercise in the L2-DS Introduction to KNIME Analytics Plat…
    knime > Education > Self-Paced Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 01 Date and Time and Databases
    knime
  2. 2019_01_04_RemoveZoneAndTime
    iris > Public > 02_ForumExamples > 2019_01_04_RemoveZoneAndTime
    iris
  3. Lab 4 - 01 - Date & Time Manipulation
    the32bitphoenix > Public > Lab 4 - Additional Examples > Lab 4 - 01 - Date & Time Manipulation
    the32bitphoenix
  4. 01 Date and Time Manipulation
    Date Time String to date&time
    +2
    Exercise for date and time manipulation. Transform date and time values from string to th…
    mcmas1999 > Assignments > Lab 04 > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 01 Date and Time Manipulation
    mcmas1999
  5. 01 Date and Time Manipulation
    Date Time String to date&time
    +2
    Exercise for date and time manipulation. Transform date and time values from string to th…
    mcmas1999 > Assignments > Lab 04 > Project 4 - mickelma > Exercises > 01 Date and Time Manipulation
    mcmas1999
  6. 01 Date and Time Manipulation - Solution
    Date Time String to date&time
    +2
    Solution to an exercise for data and time manipulation. Transform date and time values fr…
    knime > Education > Self-Paced Courses > Archive > L2-DS KNIME Analytics Platform for Data Scientists - Advanced (deprecated) > Solutions > 01 Date and Time Manipulation - Solution
    knime
  7. DateTime Manipulation
    KNIME Advanced Luck Books Date Time
    +3
    This workflow shows: - how to generate Date&Time objects (columns) from String Columns or…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter4 > 1. DateTime_Manipulation
    jeany
  8. Filter on First Business Day of Month
    This workflow filters rows with a due date less than or equal to the first business day o…
    ipazin > Public > 2019_08_21_First_Business_Day_Filter
    ipazin
  9. DateTime Manipulation
    KNIME Advanced Luck Books Date Time
    +3
    This workflow shows: - how to generate Date&Time objects (columns) from String Columns or…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter4 > 1. DateTime_Manipulation
    jeany
  10. DateTime Manipulation
    KNIME Advanced Luck Books Date Time
    +3
    This workflow shows: - how to generate Date&Time objects (columns) from String Columns or…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter4 > 1. DateTime_Manipulation
    rs1