The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Time Difference

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

Dialog Options

Select first date column
Select the column containing the start date
Select second date column
Select a second column containing the end date
Fixed time
Select a fixed time as the end date.
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

Ports

Input Ports
0 In data with at least one date columns
Output Ports
0 Out data with the time difference appended
This node is contained in KNIME Time Series Nodes provided by KNIME GmbH, Konstanz, Germany.