{"title":"Date&Time Format Manager","nodeType":"Visualizer","id":"*YWYt5ibqQAa_jpLa","factoryName":"org.knime.time.node.format.datetimeformatmanager.DateTimeFormatManagerNodeFactory","factoryId":"org.knime.time.node.format.datetimeformatmanager.DateTimeFormatManagerNodeFactory","path":["Other Data Types","Time Series","Manipulate"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Attaches display formatting to date&amp;time columns. This node changes how date&amp;time values are displayed in views, such as the Table View, without modifying the data. Locales can be specified for localized terms.\n <br />\n Helpful for formatting date&amp;time values for display in reports or data apps.</p>\n        ","shortDescription":"Attach formatter to date&time cells.","keywords":["date","time","locale","hour","minute","second","millisecond","year","month","day","formatter","day light saving"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Manipulate","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAACXBIWXMAACE4AAAhOAFFljFgAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAViSURBVHgB7VlNTBtHFH7rEHoxKL0RCaU+2D1wKUaKYn7rHEoCXCphoD3FAUU9FGo4NRVVCVUtqBoptUJv5SenikLUU2kCh7iQgKNIhROHglQTodpHhN1LKryZb+NZZpdde23jBEd80uKZ8dvd9/O9N28w0SlOcYqShkQFwOvxOA5s5MVYTlH0cSQSLkQuH5RRAYBSEknTyuSMNMP+hk3e4pBSaTlJDpvK5QEblTiOUKi5sf6RJL8K9wlA9EVKvhyJRKJmApoIeJs83hOkPOAot5E/k0DJU8g0iWvdbgpN/ERvAtOTkzQzNWlJtuQj8PZS6HUgmUzQ9tY2xWMxSiSTVGG3k51d8XjM8jPeiAGPV5ZpbnaWNtbXqVBYNmB7a4vuhn7UrA0EBsnpcmnWksyTwze/1Kz5ej6h5uZmReGx4HeKx61DGmluaHjv/1Rq1Gg/sGxA1fnz1NbeoVlDuI2gl3M5nTTNqsrM5NHKAgc4nS6yV9gpmUgq9IGz4AjVBJL95TaJtVSeI5uaZQOg7NX29rzk7oZCNP/rrEamq6eHfF3dTPEKw+dsrP9Ffyws0AN2pcE2NWm94eLFy6vPnm1QrgbkC3heVL7WXUfBsTFTxUU5XG62H2FfiMfjWD5XdrbsEYuEm0eiqGUUnBdpc723j22OE1mVF3GV0REbalVVFV86d1ZKd7ZUZAOQsBxNLS3k7+szlevxdZo+B/kXHP9enUsSeVsaG69hbJlC4ORYMKhZC46NH6lCqDCBgX51rCjAvDfwRYAKAd4DB6gRlVO32N97lg1wut6nr4aHNWtCWFWAHpBD4nI0tXyoeLFQdHX30DzbP9IVytHk8XhzqkJIKityMBal8PDF3XQceFXhOtSiYLNJHxclB7a3/lbHCP1xeJ+jts6tjmWZPiiKAbFYXB0b0awQuJyHOceS2WHZADReSErxyiTLYbdbK5nJRELZuLJBF01HTr1QoL9fs4b6jIOPCBg2ISSwFWB/wH3jrJziIONn8zaTXV9sMRj2LBuABJ6dv69ZM+qF4KGbw18rygBWWmPcA2egVGPXzWRIPPavOI3m1EpYTUa3EBWxGmUDnBSaqNMY8h+jlo/1TRxb7PxwCHmnKL0QDMUFWiDkaCn0VMsE0RB96X6w8PvhRDrzW9FaCbEjnZ78mfKBXnnQUTwEvTg4+FNyXLgg0wnFPzs7mjn6JV79ZJJmVlZXr5fMoR6tiVi6cULDZ0kYoD8QMf+PZjwPtLa2strcq86rq6spMDiofHJgzj9FWaCmpkZZZwcPzTN8Pp9GDmugySVBTgT43ue/plOeQsurkVt8YmhAZWUlfTMyoioMZXxdXbS7u6vMoVjrlSvKeHBoSJHFPRwwCOuiYhhfqq+nXBDo/1xbhmX53vLq2qAoY2jA4uIi7e/vU2faY1A2dOeO+v1HLEKRtTXNPZ2Cdz0GisIBSw8fKmNECEaKEc2CPda4DS2vRfz6Lwz3ASiPjaSXHSC41xnnNAp+Ozqqzjc3NxUjp6emlOggGvw+AHOsf3bjhqL0L6ynx/di1MyAamP2LxXANImnmDIA6IGIcIWgAF78VDAIBsCrWEd0IC8C9IED4BjkF9DR1kafCjusoXLl77yLUmn59wEReNn83JyilEgfrowITieeG0919ILS99mzgAr2PDzbCsLh8F42mYxllL9IpIPIZREwNsASFxHSRwCU0xt9XMhpH+BcNlJmiSkNGnGqcEAec+4EfMJIXGblMxfk1MyJXNYDeYB1ThUOfcVaSufTypMnxxKVnHqhXlb68HI9RTLhh9u3leoEA0UgAiI1jRB9/jzr79gnupmzYkDJ/0LzEjUYcPB1HXC+AAAAAElFTkSuQmCC","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 columns containing the attached formatter."}],"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 create a formatter for.","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":"Date&time 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;GGGG: yyyy-MMMM-dd &#39; at &#39;HH:mm[:ss[.SSS]] &#39;in&#39; VV[&#39; [also known as &#39;zzzz&#39;]&#39;]&#34; produces dates such as &#34;Anno Domini: 2024-November-26 at 22:37:59.674 in Europe/Berlin [also known as Central European Standard Time]&#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":"Alignment suggestion","description":"Position the value horizontally in compatible views like the Table View.\n<ul><li><b>Left</b> : Align the text to the left.</li><li><b>Center</b> : Center the text.</li><li><b>Right</b> : Align the text to the right.</li></ul>","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":[]}