Converts a duration to the selected field and appends the value as a long or double column. Valid fields
are hours, minutes, seconds, nano-, micro- and milliseconds. If the output should be a long value the
conversion result will be truncated, e.g. if the duration 1 hour 30 minutes should be converted to
hours, the exact output is 1.5 hours whereas the truncated output 1 hour.
Note: Only time-based durations can be converted to numbers, since
the conversion of date-based durations is not well defined (e.g.
it is not clearly defined how many days a month has).
Options
Column Selection
Conversion Settings
Popular Successors
- Rule Engine6 %
- Math Formula5 %
- GroupBy5 %
- Partitioning3 %
Column Rename3 %- Duration to Number3 %
- Column Renamer2 %
- Column Filter2 %
- Joiner2 %
- String Manipulation2 %
- Column Expressions2 %
Row Filter (deprecated)2 %- Math Formula (Multi Column)2 %
- CSV Writer1 %
- Column Resorter1 %
- Table Manipulator1 %
- Statistics1 %
- Number to String1 %
- String to Number1 %
- One to Many1 %
Row Splitter (deprecated)1 %- Normalizer1 %
- String to Number (PMML)1 %
- Rule-based Row Filter1 %
Excel Writer (XLS)1 %- Excel Writer1 %
- Line Plot (JavaScript)1 %
- Date&Time Difference1 %
- Date&Time to String1 %
- Duration to String1 %
- String to Duration1 %
Loop End< 1 %- Group Loop Start< 1 %
- Java Snippet (simple)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Concatenate< 1 %
- Column Appender< 1 %
- Linear Correlation< 1 %
- Double to Integer< 1 %
- RowID< 1 %
- Sorter< 1 %
- Rule-based Row Splitter< 1 %
- Interactive Histogram (legacy)< 1 %
- DB Writer< 1 %
- Interactive Value Filter Widget< 1 %
- String to Date&Time< 1 %
Extract Date&Time Fields< 1 %- 2D/3D Scatterplot< 1 %
- Inject Variables (Data)< 1 %
- k-Means< 1 %
- SVM Learner< 1 %
- Numeric Binner< 1 %
- Column Combiner< 1 %
- Lag Column< 1 %
- Constant Value Column< 1 %
Joiner< 1 %- Color Manager< 1 %
- Histogram Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Data to Report (BIRT)< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Modify Time< 1 %
- Moving Aggregator< 1 %
- Number Formatter< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %- Table Row to Variable< 1 %
Table Row To Variable Loop Start< 1 %CSV Writer< 1 %- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Learner< 1 %
- Simple Regression Tree Predictor< 1 %
Concatenate (Optional in)< 1 %- Auto-Binner< 1 %
- Binner (Dictionary)< 1 %
Linear Correlation< 1 %- CAIM Binner< 1 %
- Duplicate Row Filter< 1 %
- HiLite Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Rank< 1 %
- Number Rounder< 1 %
- Shuffle< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Numeric Outliers< 1 %
- IF Switch< 1 %
- Conditional Box Plot (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Line Plot (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Random Number Assigner< 1 %
- Similarity Search< 1 %
- Line Plot (Plotly)< 1 %
- Math Formula (Variable)< 1 %
- OSM Map View< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Filter< 1 %
Tableau Writer (Hyper)< 1 %- Google Sheets Updater< 1 %
- Scatter Plot (JavaScript)< 1 %
- R View (Table)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time Part Extractor< 1 %
- Extract Duration Fields< 1 %
- Time Field Extractor (legacy)< 1 %
- Table to HTML String< 1 %
Views
- This node has no views
Workflows
01_Guided_Analytics_for_ML_AutomationKNIME Hub- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- Show all 26 workflows
Links
- Complex queryby izaychik63 on 2019-12-14forum.knime.com/p/77014
- Discrepancy in the databy izaychik63 on 2024-03-27forum.knime.com/p/253284
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.