{"title":"Date&Time to String","nodeType":"Manipulator","id":"*R172f45iq6STsZWx","factoryName":"org.knime.time.node.convert.datetimetostring.DateTimeToStringNodeFactory2","factoryId":"org.knime.time.node.convert.datetimetostring.DateTimeToStringNodeFactory2","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Converts date&amp;time values to string representations using a user-defined format pattern. Locales can be specified to handle localized month or weekday names. Use this node to create customized date&amp;time string formats.\n <br />\n Often used to export date&amp;time data in a specific format for reports, files, or external systems.</p>\n        ","shortDescription":"Converts date&time cells into cells holding strings.","keywords":["convert","date","time","string","local","format","hour","minute","second","millisecond","year","month","week","day"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAVpJREFUOI2lkr9OwlAUxj/6Jwy3aTW1JSld2sWEhYXAYEdfgVfo4IBTZ+nkC7C4+AbGDgzMxMQXYDAhIS5gwtDJDtIbjwNUm9oKxF9yhpOc851zvnuBHy41TXvQdf2JMXYH4BwHIiiK8tjv9+PZbEaj0Yim0ym12+21LMvXe7vr9fptEAQJ7ej1ekRExDmnTqcTA7jYlVJJALZtr9I0paIAEdFisSBd158rZhMACN1uV5IkqbTCcRwoimJXNQMgiTEmcM7heV6piCiKtfzFAD4AhABuAIRotVpvVEGSJGSa5ktBMxPcbqGq6mQ8Hn+WCfi+/y6K4lWFB9+cGYYxj6KIZ42bzYYGg0GiquokN/FPThhj95Zlvbquu2w0GnNZlgMAQqFuaJlNssxm9ozDQ8TzEIDTQn60QC0XRzME8K8Tfm1UNGlvA7Ye1LAzuPwPVxNaZjPOktV6GX4Bevy3WFus0n4AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing date&amp;time columns."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with date&amp;time columns converted to string 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":"Date&time columns","description":"The date&amp;time columns to convert to string columns.","optional":false},{"name":"Locale","description":"The locale to use for formatting the date&amp;time. Names of months and days of the week will be translated according to the selected locale.","optional":false},{"name":"Output 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":"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":[]}