Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Modify Time
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    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. Go to item
    2019_01_04_RemoveZoneAndTime
    iris > Public > 02_ForumExamples > 2019_01_04_RemoveZoneAndTime
    iris
  3. Go to item
    Lab 4 - 01 - Date & Time Manipulation
    the32bitphoenix > Public > Lab 4 - Additional Examples > Lab 4 - 01 - Date & Time Manipulation
    the32bitphoenix
  4. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits