Time Difference (legacy)

Appends the difference between two dates with the selected aggregation level (year, quarter, month, week, day, hour, minute) and a selected precision for rounding. For the second date/time there are four possibilities. The node can be configured to use the time at execution, the entries of a second column, a fixed date/time, or the time contained in the previous row.

Options

Use execution time

Calculates the difference "current time" - "first date column"

Use second column

Calculates the difference "second date column" - "first date column"

Use fixed date

Calculates the difference "fixed date" - "first selected column"

Use previous row

Calculates in row n the difference "first date column in row n" - "first date column in row n - 1". The first cell will be missing.

Select first date column

Select the column containing the start date ("first date column")

Select second date column

Select a second column containing the end date ("second date column"; only for option "Use second column" available)

Select granularity of time difference

The granularity of the difference (in years, quarters, months, weeks, days, hours, minutes)

Rounding mode

How many fraction digits

Appended column name

Name of the newly appended column containing the time difference

Fixed time

Select a fixed time as the end date. ("fixed dates"; only for option "Use fixed date" available)

Views

This node has no views

Workflows

• 01_Simple_Statistics_on_KNIME_ForumKNIME Hub
• 02_Customers_Trx_Money_vs_LoyaltyKNIME Hub
• 02_Customers_Trx_Money_vs_LoyaltyKNIME Hub
• 03_Parsing_the_KNIME_ForumKNIME Hub
• 03_Transform_andTimeDiffKNIME Hub
• Show all 16 workflows

Links

• Determine whether two Date Ranges overlap and handle itby izaychik63 on 2018-11-05

  forum.knime.com/p/49575

Developers