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 Successors
- Math Formula4 %
- Cell Splitter3 %
- Time Difference (legacy)3 %
- Rule Engine3 %
XLS Writer2 %- Column Filter2 %
- Constant Value Column2 %
- Sorter2 %
- Number Rounder2 %
String To Number2 %- Statistics2 %
- Scatter Plot (legacy)1 %
Table Row to Variable1 %Double To Int1 %Row Filter (deprecated)1 %- GroupBy1 %
- Conditional Box Plot (legacy)1 %
- Histogram Chart (JFreeChart)1 %
- String to Date/Time (legacy)1 %
Concatenate (Optional in)1 %- Cross Joiner1 %
- Lift Chart (legacy)1 %
Extract Date&Time Fields1 %- Rule-based Row Filter< 1 %
- Table View (JavaScript)< 1 %
- Extract Time Window (legacy)< 1 %
- Concatenate< 1 %
- Numeric Binner< 1 %
Column Appender< 1 %- Column Name Extractor< 1 %
- Column Resorter< 1 %
Column Rename< 1 %- Math Formula (Multi Column)< 1 %
- Excel Writer< 1 %
- R Snippet< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
- Group Loop Start< 1 %
- Linear Regression Learner< 1 %
- Edit Numeric Domain< 1 %
- Double to Integer< 1 %
Joiner< 1 %- Joiner< 1 %
- Numeric Row Splitter< 1 %
- String Manipulation< 1 %
- Rule-based Row Splitter< 1 %
- Counter Generation< 1 %
- Column Expressions< 1 %
Excel Writer (XLS)< 1 %- Date&Time Difference< 1 %
Variable to Table Column< 1 %Database Writer< 1 %- Decision Tree Learner< 1 %
- Binner (Dictionary)< 1 %
Cell Replacer< 1 %- Lag Column< 1 %
- Nominal Value Row Filter< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- Interactive Table (legacy)< 1 %
- Line Chart (JFreeChart)< 1 %
- Preset Date/Time (legacy)< 1 %
- Outlier Removal< 1 %
- 2D/3D Scatterplot< 1 %
- Create Collection Column< 1 %
- Table Column to Variable< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- k-Means< 1 %
- Case Converter< 1 %
Linear Correlation< 1 %- Reference Row Filter< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Rule Engine (Dictionary)< 1 %
- Numeric Distances< 1 %
- Java Snippet Row Filter< 1 %
- Line Plot (JavaScript)< 1 %
- Date&Time to String< 1 %
- Date&Time Part Extractor< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
- Range Filter< 1 %
Database Connector< 1 %- CSV Writer< 1 %
Table Writer< 1 %- Fuzzy c-Means< 1 %
- Hierarchical Clustering< 1 %
- Column Comparator< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Domain Calculator< 1 %
- Nominal Value Row Splitter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Partitioning< 1 %
- Column Splitter< 1 %
- Interactive Histogram (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Color Manager< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- OSM Map View< 1 %
- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
Python Script (1⇒1)< 1 %- Column to XML< 1 %
Table to Spark< 1 %- TIBCO Spotfire File Writer< 1 %
- Set To List< 1 %
Python Plot< 1 %- R Plot< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %CSV Writer< 1 %Database Looping< 1 %Table Reader< 1 %- Java Snippet< 1 %
Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
Loop End< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %- Chunk Loop Start< 1 %
Recursive Loop Start< 1 %Naive Bayes Predictor< 1 %Logistic Regression Learner< 1 %- SOTA Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Auto-Binner< 1 %
Cell Splitter< 1 %- Column Combiner< 1 %
Number To String< 1 %- String to Number< 1 %
- Column Aggregator< 1 %
- Many to One< 1 %
- One to Many< 1 %
- CAIM Binner< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Duplicate Row Filter< 1 %
- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Normalizer< 1 %
- Numeric Binner (PMML)< 1 %
- Column Filter (PMML)< 1 %
String To Number (PMML)< 1 %- String to Number (PMML)< 1 %
- Rank< 1 %
- RowID< 1 %
- Set Operator< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Value Counter< 1 %
- Ruleset Editor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
Rank Correlation< 1 %- Kaplan-Meier Estimator< 1 %
- Numeric Outliers (Apply)< 1 %
- One-way ANOVA< 1 %
- Independent groups t-test< 1 %
- Wilcoxon Signed-Rank< 1 %
- Extract Table Spec< 1 %
Merge Variables< 1 %- Enrichment Plotter (legacy)< 1 %
- Histogram (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Save Workflow< 1 %
- Time Series Generator< 1 %
- Similarity Search< 1 %
- Box Plot (JavaScript)< 1 %
- Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
XLS Sheet Appender< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- DF< 1 %
- Value Selection (legacy)< 1 %
Python Script (1⇒1)< 1 %- R View (Table)< 1 %
- Triple File Writer< 1 %
- Date&Time to legacy Date&Time< 1 %
- String to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Modify Date< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Latitude/Longitude to Coordinate< 1 %
- HTML Parser< 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 15 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.