{"title":"UNIX Timestamp to Date&Time","nodeType":"Manipulator","id":"*uWOA5VCC8225r1HD","factoryName":"org.knime.time.node.convert.timestamptodatetime.TimestampToDateTimeNodeFactory2","factoryId":"org.knime.time.node.convert.timestamptodatetime.TimestampToDateTimeNodeFactory2","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Parses the integer or long values in the selected columns and converts them into date&amp;time cells. The inputs should be unix timestamps either in seconds, milli-, micro- or nanoseconds since the epoch (1.1.1970).\n <br />\n For the output you may choose between local and zoned date and time formats and if necessary add the timezone.</p>\n        ","shortDescription":"Parses integer or long values into into date&time cells.","keywords":[],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QA/wD/AP+gvaeTAAAACXBIWXMAABu9AAAbvQFo8EJfAAAAB3RJTUUH4QUECSgW8BZa1AAAASlJREFUOMudkjFLw1AUhb+XNLUknYSiYHabxS2gQV26Sn6Bi5DJIat7xkoRMjs6BB3tD+guIRicXB06uFYQBK9L2qbVPmq/5V3eeefAO1zFHAFUNZ8BJzVNAa/ALUuoFQE7wHZN+wDugUM0yIp7qzqfgNYmAQCflf68acBxpe9tGjAt9hdGrUy1VGqdIyAEHoFrpdQu/+AuiiIZj8eSpqkURSG+7wtwvo75ajAYyJRutzube72emKZ5oHW7rit1PM+bzZPJRIBhQ+PfD8MQgDzPabfbiMx7dhwHz/NOdQEt27YByLIMwzCI43jhgW3bW9ovBEEgOqrt1PJQluX3X+YkSQS40Loty2o0m8330Wi0YO73+wIM190DBdx0Op033/e/TNN8AS6n4g/2864R6fv/PwAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table."}],"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":"Timestamp columns","description":"The columns to convert to date&amp;time columns.","optional":false},{"name":"Timestamp granularity","description":"The unit of the input unix timestamp.","optional":false},{"name":"Output type","description":"Select the type of the new columns.\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":"Timezone","description":"Select the timezone of the new columns.","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":[]}