{"title":"Duration (Time-based) to Number","nodeType":"Manipulator","id":"*LSdmfw3bvWcDSlm2","factoryName":"org.knime.time.node.convert.durationtonumber.DurationToNumberNodeFactory2","factoryId":"org.knime.time.node.convert.durationtonumber.DurationToNumberNodeFactory2","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Converts a time-based duration to a numeric value and appends it as a long or double column. You can select fields such as hours, minutes, seconds, milliseconds, microseconds, and nanoseconds. If the output is a long value, it truncates the result (e.g., <tt>1 hour 30 minutes</tt> becomes <tt>1 hour</tt> ).\n <br />\n Often used to transform durations into numeric values for mathematical computations or aggregations.\n <br />\n <i>Note: Only time-based durations can be converted to numbers. Date-based durations are not supported because their conversion is ambiguous (for example, the number of days in a month can vary).</i></p>\n        ","shortDescription":"Converts a time-based duration to a number.","keywords":["modify","date","time","fields","hour","minute","second","millisecond","microsecond","nanosecond","period","interval"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAXpJREFUOI2dUrFOAkEQfXt4uBASKYBQIEfFQWdDco2NwQZrEz8CE4xnK1hppCDBDhsqa8VSlNhYWVMgVBDgEomKmpwQHZtTQe6Q+JrZtzPvzcxmbZjEGmNMAvAC4NUkPwE2cvaHQtIgEpHJ7XbfALDNImYA4HQ69mOx2IaqqoudTleoVqsflcpVu1a7u9B1/YyIrgE8mDZ3Oh0H2ezhIxGRruu0lUrRcaFAR/k8JRIJ8vv9bZPmBAACAI+iKOuqurMAAIPBAF2tCwDgnGM1HgfnvGUmBkACY2wlmdwMWO3ocrkQCASCBp034t5XFARB8ASDQfv3Uoyh2WyhdF5C+bKMcDgMURTfjfSbsXfG4BkAWE6nd3s0BdFo5NZqQgCwybJc7ff7puJisfgsiuL2NAMAWFIUpaFp2oTY5/OeYvyvjGE0IXm9npwkhWTOub3Xu3+q1xsnw+Ewh59Xn2pgBjJqRg1+8z8NpvK5fxpZ3VkWWRXPPMGoydgbfALNFrrH4JNCXgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing duration columns."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with duration columns converted to numeric columns."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Duration columns","description":"The columns to convert to a number.","optional":false},{"name":"Output mode","description":"The behaviour for rounding the number.\n<ul><li><b>Integer</b> : Truncates the converted number, i.e. the duration <i>1 hour 30 minutes 30 seconds</i> will be converted to <i>1 hour</i> or <i>90 minutes</i> or <i>5430 seconds</i> etc., depending upon the value of the unit of the number.</li><li><b>Decimals</b> : Outputs the exact converted number, i.e. the duration <i>1 hour 30 minutes 30 seconds</i> will be converted to <i>1.508 hours</i> or <i>90.5 minutes</i> or <i>5430.0 seconds</i> etc., depending upon the value of the unit of the number.</li></ul>","optional":false},{"name":"Granularity","description":"The unit of the number to output.","optional":false},{"name":"Output columns","description":"Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.\n<ul><li><b>Replace</b> : Replaces the selected columns by the new columns.</li><li><b>Append with suffix</b> : Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.</li></ul>","optional":false},{"name":"Output column suffix","description":"The suffix to append to the column names of the new columns.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171548","bundleName":"KNIME Date and Time Handling","bundleSymbolicName":"org.knime.time","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}