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
Popular Predecessors
- String to Date/Time (legacy)4 %
- GroupBy4 %
- Time Difference (legacy)3 %
- Extract Time Window (legacy)3 %
- Date&Time to legacy Date&Time3 %
- String to Date&Time3 %
- Joiner3 %
Table Row to Variable2 %- Row Filter2 %
- Missing Value2 %
- Rule-based Row Filter2 %
- Java Snippet2 %
- Column Filter2 %
- Moving Aggregator2 %
Variable to Table Column2 %- Column Aggregator2 %
- Sorter2 %
Excel Reader (XLS)2 %Concatenate (Optional in)1 %Cell Replacer1 %String To Number1 %Joiner1 %Column Rename1 %- String Replacer1 %
- Pivot1 %
- Date/Time Shift (legacy)1 %
- Column Merger1 %
- Rule-based Row Splitter1 %
- Modify Time Zone1 %
- Double to Integer< 1 %
- Numeric Row Splitter< 1 %
- Table Creator< 1 %
- Row Splitter< 1 %
- Table Transposer< 1 %
Excel Reader (XLS)< 1 %- Date&Time Difference< 1 %
- Feed Parser< 1 %
- CSV Reader< 1 %
- Group Loop Start< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Column Resorter< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Domain Calculator< 1 %
- Nominal Value Row Filter< 1 %
- Row Sampling< 1 %
- Rule Engine< 1 %
XLS Reader< 1 %- Legacy Date&Time to Date&Time< 1 %
Date Extractor< 1 %- Cell Splitter< 1 %
- Date&Time-based Row Filter< 1 %
- Excel Reader< 1 %
- Nominal Value Row Splitter< 1 %
- IF Switch< 1 %
- Java Snippet (simple)< 1 %
- Preset Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- XPath< 1 %
- Column List Loop Start< 1 %
- Date&Time to String< 1 %
File Reader< 1 %- Lag Column< 1 %
- Reference Row Filter< 1 %
- Color Manager< 1 %
- Math Formula< 1 %
RSS Feed Reader< 1 %- Modify Time< 1 %
- Time Generator (legacy)< 1 %
Variable to Table Row< 1 %- Numeric Binner< 1 %
- Round Double< 1 %
Merge Variables< 1 %- Extract Date&Time Fields< 1 %
Table Row To Variable Loop Start< 1 %CSV Reader< 1 %Table Reader< 1 %- Auto-Binner< 1 %
Number To String< 1 %- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Regex Split< 1 %
- String Manipulation< 1 %
- String Manipulation (Variable)< 1 %
- Statistics< 1 %
CASE Switch Data (Start)< 1 %- Time Series Generator< 1 %
Date Input (legacy)< 1 %- R Snippet< 1 %
- UNIX Timestamp to Date&Time< 1 %
Extract Date&Time Fields< 1 %Database Update< 1 %- Duplicate Row Filter< 1 %
- Empty Table Switch< 1 %
- Box Plot (legacy)< 1 %
- Parallel Chunk End< 1 %
- Partitioning< 1 %
- List Folders< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %Database Looping< 1 %Loop End< 1 %- Concatenate< 1 %
Cell Splitter< 1 %- Column Combiner< 1 %
- Column Comparator< 1 %
- Normalizer< 1 %
- Rank< 1 %
- RowID< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Timer Info< 1 %
- Column Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Single Selection (legacy)< 1 %
Python Script (1⇒1)< 1 %- Modify Date< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Coordinate to Latitude/Longitude< 1 %
Fingerprint Properties< 1 %File Meta Info< 1 %- File Meta Info (legacy)< 1 %
Variable to Table Row< 1 %- Loop End (Column Append)< 1 %
Recursive Loop End< 1 %- Case Converter< 1 %
- Category to Number< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Rename (Regex)< 1 %
- Table Validator (Reference)< 1 %
- Reference Column Filter< 1 %
- Column Splitter< 1 %
- Global Timer Info< 1 %
- Save Workflow< 1 %
- Counter Generation< 1 %
- Similarity Search< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Tika Language Detector< 1 %
- Google Sheets Reader< 1 %
- Date&Time Configuration< 1 %
- Container Input (JSON)< 1 %
- Don't Save Start< 1 %
Double Input (legacy)< 1 %- Create Date&Time Range< 1 %
- Extract Duration Fields< 1 %
- Date&Time Shift< 1 %
Web Log Reader< 1 %- Web Log Reader< 1 %
Hash Calculator< 1 %- Column Appender< 1 %
- DB Query Reader< 1 %
- Column Expressions< 1 %
- JSON Path< 1 %
Views
- This node has no views
Workflows
01_Simple_Statistics_on_KNIME_ForumKNIME Hub- 02_Customers_Trx_Money_vs_LoyaltyKNIME Hub
- 03_Parsing_the_KNIME_ForumKNIME Hub
- 03_Transform_andTimeDiffKNIME Hub
- 04_Parsing_the_KNIME_ForumKNIME Hub
- Show all 13 workflows
Links
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.