Icon

kn_​forum_​38140_​utc_​timestamp_​convert

Quick fix for Date/Time question with different length of parts of seconds

Quick fix for Date/Time question with different length of parts of seconds

Quick fix for Date/Time question with different length of parts of secondshttps://forum.knime.com/t/unable-to-convert-date-time-with-time-zone-using-string-to-date-time-node/38140 import.txtyyyy-MM-dd HH:mm:ss.[SSS] zzzzyyyy-MM-dd HH:mm:ss.S[SSSS] zzzzTime1Time2Node 7MISSING $Time2$ => $Time1$TRUE => $Time2$yyyy-MM-dd HH:mm:ss.[SSS] zzzzTime2MISSING $Time2$ => $Time1$TRUE => $Time2$Time1yyyy-MM-dd HH:mm:ss.S[SSSS] zzzz File Reader String to Date&Time String to Date&Time Column Rename Column Rename Joiner Rule Engine String to Date&Time Column Rename Rule Engine Column Rename String to Date&Time Quick fix for Date/Time question with different length of parts of secondshttps://forum.knime.com/t/unable-to-convert-date-time-with-time-zone-using-string-to-date-time-node/38140 import.txtyyyy-MM-dd HH:mm:ss.[SSS] zzzzyyyy-MM-dd HH:mm:ss.S[SSSS] zzzzTime1Time2Node 7MISSING $Time2$ => $Time1$TRUE => $Time2$yyyy-MM-dd HH:mm:ss.[SSS] zzzzTime2MISSING $Time2$ => $Time1$TRUE => $Time2$Time1yyyy-MM-dd HH:mm:ss.S[SSSS] zzzz File Reader String to Date&Time String to Date&Time Column Rename Column Rename Joiner Rule Engine String to Date&Time Column Rename Rule Engine Column Rename String to Date&Time

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2021-12-11
On NodePit since: 2021-12-11
Last update: 2024-04-27
Created with KNIME version: v4.5.0
Tags: UTCtimezoneseconds

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!