{"title":"Legacy Date&Time to Date&Time","nodeType":"Manipulator","id":"*prhDzI0ZZh7WvMOY","factoryName":"org.knime.time.node.convert.oldtonew.OldToNewTimeNodeFactory","factoryId":"org.knime.time.node.convert.oldtonew.OldToNewTimeNodeFactory","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 old Date&amp;Time data type to the new types. 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        ","shortDescription":"Converts old Date&Time to new.","keywords":[],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAATJJREFUOI2dkr1qAkEUhb8ZdokL/oCdsM2iYOEDKPgOlhaWljZWvolNHiK9tQR8AQshsKRJY2HlNLJw0qgZdTQxB6aYn+/ccy8DP2rHcfyWJMm7tfYVaPOEpmmabtfrtebzuZbLpVqt1haY/gXuN5vNXVEUkqRutytJKopCnU5nB/TvcAaAKIpWeZ7rpJOBJOV5riRJVkdA3job2HK5nGZZFiyRZRmVSiX1AONdCzCRMcYA9Hq9oIm11odebh6USqWNc04hOedUrVY3V8hFCwCTwWCwDxmMRqM9MAnMwJ8Fxlq7GA6H5xiHw0Hj8djFcbwI9H0Bn1sFZvV6/bPRaHzVarUPYHY892VC8DMyvx54Ue9VPe0NoOuIj8wNt3+B6IHBvVT/NrhOJLid8m+APwsL8A1NyKK3aSM7fAAAAABJRU5ErkJggg==","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":"Extracted converted","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":"Columns to convert","description":"Move columns between the lists to specify which legacy Date&amp;Time columns (old type) should be converted to the new KNIME Date&amp;Time types. Only columns compatible with the legacy Date&amp;Time data type are shown.","optional":false},{"name":"Automatic type detection","description":"If enabled the new type for each included column is inferred from the first non-missing cell: the legacy value&#39;s components (date / time / both) decide whether Date, Time, Date &amp; time or (optionally) Date &amp; time &amp; zone is chosen.","optional":false},{"name":"Manual new type","description":"Choose the target Date&amp;Time type to which all included columns will be converted when automatic type detection is disabled.\n<ul><li><b>Date</b> : Outputs values of type Date</li><li><b>Time</b> : Outputs values of type Time</li><li><b>Date &amp; time</b> : Outputs values of type Date&amp;time (Local)</li><li><b>Date &amp; time &amp; zone</b> : Outputs values of type Date&amp;time (Zoned)</li></ul>","optional":false},{"name":"Add time zone, if possible","description":"When enabled this option attempts to upgrade legacy values containing both Date &amp; Time components to Date &amp; time &amp; zone by attaching the selected time zone. If a value contains date only or time only no time zone is added.","optional":false},{"name":"Time zone","description":"The IANA time zone identifier used either (a) when automatic type detection is enabled and &#39;Add time zone&#39; is checked, or (b) when manual type selection is active and the chosen type is Date &amp; time &amp; zone.","optional":false},{"name":"Output mode","description":"Select how converted columns should appear in the output.\n<ul><li><b>Append selected columns</b> : Keep the original columns and add new columns with a configurable suffix.</li><li><b>Replace the selected columns</b> : Overwrites the original columns.</li></ul>","optional":false},{"name":"Suffix of appended columns","description":"Suffix appended to each converted column when <b>Append selected columns</b> is chosen. Must yield unique column names.","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":"*4jYLvUyY8JJfwp4Q","factoryName":"org.knime.time.node.filter.datetimebasedrowfilter.DateTimeBasedRowFilterNodeFactory","probability":0.13229571984435798},{"id":"*9fwSs7H-HKfJ5L8V","factoryName":"org.knime.time.node.calculate.datetimedifference.DateTimeDifferenceNodeFactory","probability":0.10505836575875487},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.0946822308690013},{"id":"*1IV13SZKupKfvBzO","factoryName":"org.knime.time.node.extract.datetime.ExtractDateTimeFieldsNodeFactory","probability":0.0933852140077821},{"id":"*HqED49mBqBl-sfCF","factoryName":"org.knime.time.node.convert.datetimetostring.DateTimeToStringNodeFactory","probability":0.08949416342412451},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.054474708171206226},{"id":"*0Uk7y3_4UI7R8yjM","factoryName":"org.knime.time.node.convert.newtoold.NewToOldTimeNodeFactory","probability":0.02204928664072633},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.02204928664072633},{"id":"*F0p6pjWbjEGovUdJ","factoryName":"org.knime.timeseries.node.extract.date.DateFieldExtractorNodeFactory","probability":0.019455252918287938},{"id":"*sLTXYsycpYMwt_yW","factoryName":"org.knime.time.node.convert.stringtodatetime.StringToDateTimeNodeFactory","probability":0.018158236057068743}]}