{"title":"Date&Time Difference","nodeType":"Manipulator","id":"*aH2fTw7aINVnPJQu","factoryName":"org.knime.time.node.calculate.datetimedifference.DateTimeDifferenceNodeFactory2","factoryId":"org.knime.time.node.calculate.datetimedifference.DateTimeDifferenceNodeFactory2","path":["Other Data Types","Time Series","Manipulate"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Calculates the difference between two date&amp;time columns and appends the result in a new column. The difference can be output as either a duration or a number with a specified granularity (years, months, weeks, days, hours, minutes, seconds, milliseconds, nanoseconds). You can select the second date&amp;time from another column, the execution date&amp;time, a fixed date&amp;time, or the previous row&#39;s date&amp;time.\n <br />\n This node is commonly used to calculate time intervals between events for time series analysis or process monitoring.</p>\n        ","shortDescription":"Calculates differences between two date&time values.","keywords":["calculate","subtract","minute","second","millisecond","day","month","week","delta"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Manipulate","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAOxgAADsYB6tXNkgAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAIYSURBVDiNlZO/SxtxGMY/97373pUjghq8xZAEcsTERFCkUEJ0yFTsGnQVMhS6Cv4NXWoRacFdHcRJcQpaCqWZ8g80P4d2jRhScuZ+daqEqNQ+0/vC83ngeeGFCaVSqUImk/lqWdZvXdcDKaVrGMYP4COQm/QrY7Nu23a11WqtLywssLKywszMDOl0Gk3TODk5GdZqNUNRlM9BEOwAo/EAPRaLtQeDwXylUiGdTgNwdHSEZVmcnZ0BcH19zebm5t3t7e13z/NeAyMBYNt2td/vz+/u7t7DAKPRCMdx7vdSqUS9XjcikUhBCPEBQCSTyVftdnt9e3ubaDQ6WfGBEokEx8fHRhiG74CcMAzjfTweJ5d7cJ8ntbGxQT6fd4CK6PV6L5eXl58N/9XW1pap6/obrd/vv7AsC4DBYMDFxQW+7wPQ6XQIguDRANu28X0/pgVB4GcyGbG2tsbNzQ31eh3P8+6NxWLx0YAwDFEUBU3X9V/D4TCZzWYBKBQKz6rQbDZRVfUnUsqD1dVVL/xPLS0tDYE9gLwQIri8vHw2fH5+HiqK4gOLAJimeRiNRt1ut/tPuNPphNPT03eqqh6MV9JN0/w2NzfnXl1dPQlXq9Vwdnb2zjCML4CEiWcyTXPfcZy3xWIxKJfLqm3bADQaDU5PT91araaqqvrJdd0dwH3qwItSyv2pqam2lNLRNG0YiURaQog9IDtp/gPoPUngQH9CXwAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing a date&amp;time column."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table containing an appended column with the differences."}],"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":"First date&time column","description":"The first date&amp;time column. The first and second column will be subtracted from each other, with the direction depending on the &#39;mode&#39; option.","optional":false},{"name":"Second date&time value","description":"The source of the second date&amp;time value.\n<ul><li><b>Column</b> : Calculates the difference between the selected second column and the first column. Differences can only be calculated between columns of the same type. Using the <i>Modify Time</i> , <i>Modify Date</i> , and <i>Modify Time Zone</i> nodes you can adjust the date&amp;time formats beforehand.</li><li><b>Fixed date&amp;time</b> : Calculates the difference between the selected fixed date&amp;time and the first column.</li><li><b>Execution date&amp;time</b> : Calculates the difference between the execution date&amp;time and the chosen first column.</li><li><b>Previous row</b> : Calculates the difference between the date&amp;time in row <i>n</i> and row <i>n-1</i> in the chosen row. Note that the first row in the output will be MISSING as there is no previous row to calculate the difference with.</li></ul>","optional":false},{"name":"Second date&time column","description":"The second date&amp;time column to calculate the difference to.","optional":false},{"name":"Date","description":"The fixed date to calculate the difference to.","optional":false},{"name":"Time","description":"The fixed time to calculate the difference to.","optional":false},{"name":"Local date&time","description":"The fixed local date&amp;time to calculate the difference to.","optional":false},{"name":"Zoned date&time","description":"The fixed zoned date&amp;time to calculate the difference to.","optional":false},{"name":"Mode","description":"The mode in which the date&amp;time values are subtracted from each other: either subtract the second value from the first, or subtract the first from the second.","optional":false},{"name":"Output type","description":"The type of the output column.","optional":false},{"name":"Granularity","description":"The unit of the output column when converting to a number.","optional":false},{"name":"Output number type","description":"The type of the numeric output column.\n<ul><li><b>No decimals</b> : The output column will be an integer. Applicable for all granularities.</li><li><b>Decimals</b> : The output column will be a floating-point number. Not applicable for date-based granularities.</li></ul>","optional":false},{"name":"Output column name","description":"The name of the output column.","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":[]}