I was searching through the forum but did not find any solution to below:
I am trying to convert string to date&time data type. I know of the node “String to Date&time” but that node only accepts one format.
But, I have 2 formats of date one column as below:
here I want to extract these 6 columns as date&time from string data type.
I configured “String to date&time” node to extract using following configurations:
Here it does work for the one I parsed but throws error on 00:00 as below:
ERROR String to Date&Time 0:7 Execute failed: Failed to parse date in row '1: Text ‘00:00’ could not be parsed at index 0
Kindly help me understand how I can parse multiple date formats from same column from string to date and time data type using KNIME?
Hello @ipazin!
The solution in option 1 will not help as the format change without any pattern and I need for all 5 columns, any column can have any format in any row without fixed pattern.
I am following the solution in option 2 and will see if that works and get back to you with the same.
Hello @ipazin !
None suggestions work for me as mentioned as I just saw my data set has even more formats…
Even regex does not seem to work.
I have some 3-5 formats in one column randomly occurring among the 5 consecutive columns.
the below are the formats:
hh:mm:ss
hh:mm
YYYY-MM-DD’T’hh:mm:ss
YYYY-MM-DD
And I want to convert these to date&time data type.
Is there any other way to handle this?