{"title":"Date&Time to legacy Date&Time","nodeType":"Manipulator","id":"*0Uk7y3_4UI7R8yjM","factoryName":"org.knime.time.node.convert.newtoold.NewToOldTimeNodeFactory","factoryId":"org.knime.time.node.convert.newtoold.NewToOldTimeNodeFactory","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node converts columns from the new Date&amp;Time data types to the legacy type. It is only useful if you have to use nodes that have not been adapted to the new Date&amp;Time type yet.</p>\n            \n        \n        ","shortDescription":"Converts new Date&Time to old.","keywords":[],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAASZJREFUOI2dkT+Kg0AYxd/owKRQsLKyGVLEGyjkDpaWHiBNqtzEZg+xfeqwkAtYBAKyzTYpUmUaEd426vovkuwPZBhn3vve9w3wx8a27U+l1JcQ4gPABm+wD4LgVhQF8zzn6XSi1voGYP+KeLter+91XZMkoygiSdZ1zTAM7wC2T3QCACClPJdlyZbWgCTLsqRS6twI2Ps6A8txnEBrPVtCaw3XdYOeQIzvSCGEAIA4judzNucNanJhtVpdjDGcwxhDx3EuI8mgBQDYJUnymDNI0/QBYDczg/4sICzLOqZp2sWoqopZlhkp5XHU90TcYgE4eJ737fv+j+u6VwCH5v9gJHPid5i8wjPGUcdVu7NxxFeqid7KJYOldB3/MRiwZPC0797e+gVjYKVHVR12WAAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table to be converted","description":"Input table"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Converted table","description":"Output table containing the converted 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":"Column selection","description":"Only the included columns will be converted.","optional":false},{"name":"Time zone handling","description":"The legacy <b>Date&amp;Time</b> type does not support time zones. When converting values, you can choose how the time zone information should be handled:\n<ul><li><b>Add as offset</b> : Uses the provided time zone to convert the value to a UTC-based timestamp.\n  <ul><li><i>Input</i> : 2015-07-09T13:00:00&#43;02:00[Europe/Berlin]</li><li><i>Output</i> : 09.Jul.2015 15:00:00</li></ul></li><li><b>Drop</b> : Removes any time zone information from the value.\n  <ul><li><i>Input</i> : 2015-07-09T13:00:00&#43;02:00[Europe/Berlin]</li><li><i>Output</i> : 09.Jul.2015 13:00:00</li></ul></li></ul>","optional":false},{"name":"Output columns","description":"Whether to replace the original columns with the converted columns, or to append the converted columns with new names created by appending the specified suffix to the original column names.\n<ul><li><b>Replace</b> : Replace each input column with the converted dates.</li><li><b>Append with suffix</b> : For each input column append a new column with the converted dates.</li></ul>","optional":false},{"name":"Suffix","description":"Text appended to column names when new columns are created using the Append option.","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":[{"id":"*5xTQbnNLONK0vecv","factoryName":"org.knime.base.node.io.database.DBWriterNodeFactory","probability":0.11954022988505747},{"id":"*prhDzI0ZZh7WvMOY","factoryName":"org.knime.time.node.convert.oldtonew.OldToNewTimeNodeFactory","probability":0.08275862068965517},{"id":"*F0p6pjWbjEGovUdJ","factoryName":"org.knime.timeseries.node.extract.date.DateFieldExtractorNodeFactory","probability":0.06896551724137931},{"id":"*y7mLWnM4uzBYDvWZ","factoryName":"org.knime.timeseries.node.mask.MaskTimeNodeFactory","probability":0.06896551724137931},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.06896551724137931},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.041379310344827586},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.02528735632183908},{"id":"*9fwSs7H-HKfJ5L8V","factoryName":"org.knime.time.node.calculate.datetimedifference.DateTimeDifferenceNodeFactory","probability":0.02528735632183908},{"id":"*1IV13SZKupKfvBzO","factoryName":"org.knime.time.node.extract.datetime.ExtractDateTimeFieldsNodeFactory","probability":0.02528735632183908},{"id":"*Y6V4A_SYiGNNFmY0","factoryName":"org.knime.timeseries.node.diff.TimeDifferenceNodeFactory","probability":0.02528735632183908}]}