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. 2019_01_04_RemoveZoneAndTime
    iris > Public > 02_ForumExamples > 2019_01_04_RemoveZoneAndTime
  2. 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
  3. 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
  4. 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 > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Solutions > 01 Date and Time Manipulation - Solution
  5. 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
  6. 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
  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.3_20210222 > Chapter4 > 1. DateTime_Manipulation
  8. 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…
    kzhqtt > Public > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Solutions > 01 Date and Time Manipulation - Solution
  9. Date and Time Manipulation
    kzhqtt > Public > _WA_American-Time-Use-Survey > Date and Time Manipulation
  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