Icon

DateTime_​Intermittent_​Error

Trying to add a column with current date/time as generated by the Date&Time Input nodeThe 'String to Date&Time' node fails if the milliseconds are only 2 digits long (ie. the 3rd digitwould have been a zero) WORKAROUND. A workaround is possible by using String Manipulation to reduce thegranularity to seconds but this is clunky Currentdate/timeAdd columnDateTime withcurrent date/timeConvert todate/time data typeCreate1col, 1rowAdd columnDateTime withcurrent date/time1st 19chars only(Granularity downto seconds)Convert todate/time data type Date&Time Input ConstantValue Column String to Date&Time Table Creator ConstantValue Column String Manipulation String to Date&Time Trying to add a column with current date/time as generated by the Date&Time Input nodeThe 'String to Date&Time' node fails if the milliseconds are only 2 digits long (ie. the 3rd digitwould have been a zero) WORKAROUND. A workaround is possible by using String Manipulation to reduce thegranularity to seconds but this is clunky Currentdate/timeAdd columnDateTime withcurrent date/timeConvert todate/time data typeCreate1col, 1rowAdd columnDateTime withcurrent date/time1st 19chars only(Granularity downto seconds)Convert todate/time data typeDate&Time Input ConstantValue Column String to Date&Time Table Creator ConstantValue Column String Manipulation 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: dp-l
Created at: 2022-02-05
On NodePit since: 2022-03-10
Last update: 2024-11-24
Created with KNIME version: v4.3.2

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

Try NodePit Runner!