Date&Time Shift

The node shifts a date or time with a defined duration or granularity. The user can select the Date&Time columns to shift and the shift value. The shift value can be achieved by using either a duration column or a numerical column, however, it is also possible to enter a constant shift value (either duration or numerical combined with a granularity). If the shift value is positive, it is added to the selected date. A negative value will be subtracted. A numerical value is interpreted based on the selected granularity (year, month, week, day, hour, minute, second, millisecond, nanosecond).

Options

Column Selection

Column Selector

Only the included columns will be shifted.
Note: A LocalTime can not be shifted by years, months or weeks. A LocalDate can not be shifted by hours, minutes or seconds.

Replace/Append Selection

Append selected columns

The selected columns will be appended to the input table. The suffix of the appended columns can be provided in the text field to the right.

Replace selected columns

The selected columns will be replaced by the new columns.

Use Duration

Duration column

Select to choose the shift value from a duration column.

Duration value

Select to insert a format string to use as constant shift value. The inserted string can be either in
1. the ISO-8601 representation (see date-based duration format or time-based duration format for details), examples below,
2. the short letter representation (e.g. '2y 3M 1d')
Date-based duration: y: years, M: months, d: days
Time-based duration: H: hours, m: minutes, s: seconds
or
3. the long word representation (e.g. '2 years 3 months 1 day').

Examples for ISO-8601 (date-based duration):

• "P2Y" parses as "+2 years"
• "P-2Y" parses as "-2 years"
• "P1Y2M3W4D" parses as "1 year, 2 months, 3 weeks and 4 days"

Examples for ISO-8601 (time-based duration):

• "PT15M" parses as "+15 minutes"
• "-PT15M" parses as "-15 minutes"
• "PT2H15M3.5S" parses as "2 hours, 15 minutes and 3.5 seconds"

Use Numerical

Numerical column

Select to choose the shift value from a numerical column. A positive value will be added to the reference date or time, a negative one subtracted from it.

Numerical value

Select to insert an integer to use as constant shift value. A positive value will be added to the reference date or time, a negative one subtracted from it.

Granularity

The granularity of the numerical value (in years, months, weeks, days, hours, minutes, seconds, milliseconds, nanoseconds).

Input Ports

Input table.

Output Ports

Output table with shifted columns.

Best Friends (Incoming)

• String to Date&Time (15 %) Streamable
• Create Date&Time Range (8 %) 
• Date&Time Shift (6 %) Streamable
• Math Formula (5 %) Streamable
• Row Filter (4 %) Streamable
• Show all 179 recommendations

Best Friends (Outgoing)

• Extract Date&Time Fields (8 %) Streamable
• Date&Time to String (8 %) Streamable
• Column Rename (8 %) Streamable
• Joiner (7 %) 
• Date&Time Shift (7 %) Streamable
• Show all 184 recommendations

Workflows

• 01_​Clickstream_​Analysis (KNIME Hub) 
• 01_​Data_​Preparation (KNIME Hub) 
• 01_​Stocks (KNIME Hub) 
• 01_​Stocks (KNIME Hub) 
• 01_​Stocks (KNIME Hub) 
• Show all 43 workflows

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.