This plugin is currently not available in KNIME v5.9 — instead we’re showing this page for KNIME v4.5. You can use the version menu in the title bar to permanently switch your preferred version. This will also show the link to the update site.
This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
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 Predecessors
Row Filter (deprecated)5 %String To Number4 %- String to Number4 %
Joiner3 %Date&Time Difference3 %- Joiner3 %
Modify Date2 %Date&Time to String2 %Extract Duration Fields2 %- Loop End2 %
- Math Formula2 %
Duration to Number2 %String to Duration2 %- Date&Time-based Row Filter2 %
- Concatenate2 %
- Math Formula (Multi Column)2 %
File Reader1 %Column Appender1 %- Lag Column1 %
- Column Filter1 %
- GroupBy1 %
- Sorter1 %
String to Date&Time1 %Date&Time Shift1 %CSV Reader1 %- Number to String1 %
- Column Resorter1 %
- Missing Value1 %
Column Rename1 %- String Manipulation1 %
- Rule Engine1 %
- Timer Info1 %
Modify Time1 %- Moving Aggregator1 %
- Excel Reader1 %
- Legacy Date&Time to Date&Time1 %
- Date&Time Part Extractor1 %
- Column Appender1 %
- Unpivot1 %
Excel Reader (XLS)1 %- Reference Row Splitter1 %
- Color Manager1 %
Excel Reader (XLS)1 %- Date&Time to legacy Date&Time1 %
Create Date&Time Range1 %- Cross Joiner< 1 %
- Java Snippet< 1 %
Row Splitter (deprecated)< 1 %Duration to String< 1 %Extract Date&Time Fields< 1 %- Number Rounder< 1 %
- IF Switch< 1 %
- Table Creator< 1 %
- Rule-based Row Splitter< 1 %
Concatenate (Optional in)< 1 %- Pivot< 1 %
Color Appender< 1 %- Column Expressions (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
Database Reader< 1 %Line Reader< 1 %Loop End< 1 %- Category to Number< 1 %
- String Replacer< 1 %
- String to Date/Time (legacy)< 1 %
- Uniquify IDs< 1 %
- Column Combiner< 1 %
- Number to Category (Apply)< 1 %
Constant Value Column< 1 %- Duplicate Row Filter< 1 %
- String to Number (PMML)< 1 %
- Set Operator< 1 %
- Rule-based Row Filter< 1 %
- DB Query Reader< 1 %
- String to Term< 1 %
- Boolean Input (legacy)< 1 %
Python Script (1⇒1)< 1 %- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
- CSV Reader< 1 %
- Recursive Loop Start< 1 %
Cell Replacer< 1 %- Cell Splitter By Position< 1 %
- Table Manipulator< 1 %
- String Input (legacy)< 1 %
UNIX Timestamp to Date&Time< 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 33 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.