Date/Time Shift (legacy)

Manipulator

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).

Input Ports

  1. Type: Data
    Table to be shifted or empty table

Output Ports

  1. Type: Data
    Out data with the shifted date appended

Extension

This node is part of the extension

KNIME Core

v4.0.0

Short Link

Drag node into KNIME Analytics Platform