{"title":"String to Date&Time","nodeType":"Manipulator","id":"*S0CYCPOs6qCN_QYQ","factoryName":"org.knime.time.node.convert.stringtodatetime.StringToDateTimeNodeFactory2","factoryId":"org.knime.time.node.convert.stringtodatetime.StringToDateTimeNodeFactory2","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Parses strings in selected columns and converts them to date&amp;time cells. You can choose from common date&amp;time formats or specify a custom format. Locales can be set to handle localized month or weekday names.\n <br />\n Useful when converting imported date strings into date&amp;time format for analysis and processing.</p>\n        ","shortDescription":"Parses date and/or time strings into date&time cells.","keywords":["convert","date","time","string","local","parse","hour","minute","second","millisecond","year","month","day","week"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAXFJREFUOI2FUrFqAkEQfbt34sGKJOd5Oe4CYpvCxkIxViF/4RckFgFLK61SxcoqPxEQBGub/ICBhIBdErA4m+yBetykyGkS3bs8WIZ5M/N23rIA0HNtj1zbIwAEoIcfkOIcgAAc7+VM1agSYDHJ05oU/O4CDqAPIHJtLwIQ4a8FAMjGsb8XE6HagKXUdm/A4o2SLDgqUgfQd23P3xLvi7eDFRljl8Vi8UrTtJPVavXk+/4AwEuih1/gpmk+tFotfzab0XA4pOl0StVqdSGEuPl3Op/P33a7XUkxarUaERGFYUj1et3nnJ+nzWdKpdL7ZrOhfQEiovl8To7jPPIUgbNGo6Hruq4slstlCCFO1dVvZIUQPAxDNJtNZYOmaUk/FgBwVKlUPigBUkpyXfc5TQCWZU3G43GkEmi325+GYVynCgCwHMd5HY1G4XZwvV5Tp9ORhUJhAoClethaMU1zkMvlLgzDyEgpg+VyeR8EwR2A6AsiOsZiSvl/tgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing string columns with date&amp;time information."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table containing the parsed 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":"String columns","description":"The string columns to convert to date&amp;time columns.","optional":false},{"name":"Locale","description":"A locale can be chosen, which determines the language and geographic region for terms such as months or weekdays.","optional":false},{"name":"Output type","description":"The date&amp;time type to parse the input strings into.","optional":false},{"name":"Input format","description":"A format string (defined by <a href=\"https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/time/format/DateTimeFormatter.html\" rel=\"ugc nofollow noopener noreferrer\">DateTimeFormatter</a> ).\n<br />\n<b>Examples:</b>\n<ul><li>&#34;yyyy.MM.dd HH:mm:ss.SSS&#34; produces dates such as &#34;2001.07.04 12:08:56.000&#34;</li><li>&#34;yyyy-MM-dd&#39;T&#39;HH:mm:ss.SSSZ&#34; produces dates such as &#34;2001-07-04T12:08:56.235-0700&#34;</li><li>&#34;yyyy-MM-dd&#39;T&#39;HH:mm:ss.SSSXXX&#39;[&#39;VV&#39;]&#39;&#34; produces dates such as &#34;2001-07-04T12:08:56.235&#43;02:00[Europe/Berlin]&#34;</li></ul>\n<b>Supported placeholders in the pattern are:</b>\n<ul><li>G: era</li><li>u: year</li><li>y: year of era</li><li>D: day of year</li><li>M: month in year (context sensitive)</li><li>L: month in year (standalone form)</li><li>d: day of month</li><li>Q/q: quarter of year</li><li>Y: week based year (you probably want to use y instead)</li><li>w: week of week based year</li><li>W: week of month</li><li>E: day of week</li><li>e: localized day of week\n  <ul><li>e: 4</li><li>ee: 04</li><li>eee: Wed</li><li>eeee: Wednesday</li><li>eeeee: W</li></ul></li><li>c: day of week</li><li>F: day-of-week in month</li><li>a: am/pm of day</li><li>h: clock hour of am/pm (1-12)</li><li>K: hour of am/pm (0-11)</li><li>k: clock hour of am/pm (1-24)</li><li>H: hour of day (0-23)</li><li>m: minute of hour</li><li>s: second of minute</li><li>S: fraction of second</li><li>A: milli of day</li><li>n: nano of second</li><li>N: nano of day</li><li>V: time zone ID</li><li>z: time zone name</li><li>O: localized zone offset</li><li>x: zone offset (ISO8601)\n  <ul><li>X: &#43;08 or &#43;0830</li><li>XX: &#43;0800 or &#43;0830 (no colons)</li><li>XXX: &#43;08:00 or &#43;08:30 (with colons)</li><li>XXXX: &#43;0800 or &#43;083015 (i.e. including offset seconds, no colons)</li><li>XXXXX: &#43;08:00 or &#43;08:30:15 (i.e. including offset seconds, with colons)</li></ul></li><li>X: same as x, but outputs Z when offset is 0</li><li>Z: zone offset (RFC822)\n  <ul><li>Z, ZZ, ZZZ: &#43;0800 or &#43;0830</li><li>ZZZZ: GMT&#43;08:00 or GMT&#43;08:30</li><li>ZZZZZ: &#43;08:00 or &#43;08:30:15</li></ul></li><li>p: pad next</li><li>&#39; : escape for text</li><li>&#39;&#39;: single quote</li><li>[: optional section start</li><li>]: optional section end</li></ul>","optional":false},{"name":"Auto-guess format and output type","description":"<p>Try to guess the format of the selected column and set the format accordingly.</p>\n<p>This is done by checking the first 1000 non-missing rows of the first selected column and trying to find a suitable format that can parse every entry. If no suitable format is found, the format will be set to an empty string.</p>","optional":false},{"name":"If extraction fails","description":"If set to &#39;Fail&#39;, the node will abort the execution and fail on errors. Otherwise, missing values will be generated instead.\n<ul><li><b>Insert missing</b> : Sets the output cell to missing if the string column cannot be converted to the specified type.</li><li><b>Fail</b> : Fails with an error if the string column cannot be converted to the specified type.</li></ul>","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":[]}