Date&Time Difference

Calculates differences between two date&time cells and appends a new column. The output can be either a duration or a selected granularity (years, months, weeks, days, hours, minutes, seconds, millis, nanos). It can be configured to use as second date&time either a second column, the execution date&time, a selected fixed date&time or the date&time contained in the previous row.

Options

Base column

Column Selector

The first date&time column can be chosen.

Calculate difference to

second column

Calculates the difference between the selected second column and the first column. Differences can only be calculated between columns of the same type. Using the Modify Time, Modify Date, and Modify Time Zone nodes you can adjust the date&time formats beforehand. The first column will be subtracted from the second column (second column - first column).

execution date&time

Calculates the difference between the execution date&time and the chosen first column. The first column will be subtracted from the execution date&time (execution date&time - first column).

fixed date&time

Calculates the difference between the chosen fixed date&time and the chosen first column. The first column will be subtracted from the fixed date&time (fixed date&time - first column).

previous row

Calculates the difference between the date&time in row n and row n-1 in the chosen column. The n-1th row will be subtracted from the nth row ( nth row - n-1th row ).

Output options

Granularity

Calculates the difference and outputs it in the chosen granularity (years, months, weeks, days, hours, minutes, seconds, millis, or nanos).

Duration

Calculates the difference and outputs it as either date-based or time-based duration. If the difference between local or zoned date&time columns is calculated, differences of years, months, or days will be converted to hours.

New column name

The name for the new column can be chosen.

Views

This node has no views

Workflows

• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• 004_Asset_Utilization (3)KNIME Forum
• 004_Asset_Utilization_pigrecoKNIME Forum
• 01 Date and TimeKNIME Hub
• 01_04_Supply_Chain_Inventory_Management_KPIsKNIME Hub
• Show all 694 workflows

Links

• Booking time vs. cancellation correlationby armingrudd on 2019-05-12

  forum.knime.com/p/60388
• DATE FORMULAby HansS on 2024-09-13

  forum.knime.com/p/269295
• Average time between datesby qqilihq on 2018-10-30

  forum.knime.com/p/49305
• How to calculate a series of dates from different accounts in the same table and see if they fall within a specified time period between each other.by armingrudd on 2019-07-27

  forum.knime.com/p/66538
• Complex queryby izaychik63 on 2019-12-14

  forum.knime.com/p/77014
• Show all 8 links

Developers