Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Date/Time Shift (legacy)
NodeNode / Manipulator

Date/Time Shift (legacy)

Other Data Types Time Series Time Series (legacy)
Drag & drop
Like
Copy short link

The node shifts a date/time with a defined granularity. The user can select the date reference and the shift value. The date can be chosen as a Date/Time column, as the execution time or as a fixed entered date. The shift value can be achieved by using a numerical column, however, it is also possible to enter a constant shift value. The numerical shift value is added to the selected date. The value is interpreted based on the selected granularity (year, quarter, month, week, day, hour, minute).

Node details

Input ports
  1. Type: Table
    Input table
    Table to be shifted or empty table
Output ports
  1. Type: Table
    Shifted date
    Out data with the shifted date appended

Extension

The Date/Time Shift (legacy) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    2017_01_23_WindGust
    iris > Public > 02_ForumExamples > 2017_01_23_WindGust
    iris
  2. Go to item
    convert excel number (or string) to date
    Excel Date Number
    +3
    convert excel number (or string) to date
    mlauber71 > Public > forum > kn_forum_27849_excel_number_to_date
    mlauber71
  3. Go to item
    JWT-Check-Expiration
    jtyler > Public > JWT-Check-Expiration
    jtyler
  4. Go to item
    Deal with (messy) Time formats containing AM/PM distincions
    Am Pm Date
    +3
    Deal with (messy) Time formats containing AM/PM distincions
    mlauber71 > Public > kn_example_date_time_am_pm_format
    mlauber71
  5. Go to item
    Challenge
    gabbo2409 > Knime_Challenge_Team 2 > Challenge
    gabbo2409
  6. Go to item
    TR_Reports_IncidentMetric3
    lp00557408 > Public > TR_Reports_IncidentMetric3
    lp00557408
  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