String to Date time

Hi, my date time column cannot be read as Date Time in Knime. And I tried to use the String to Date time node it is not working and showed the error message. Can anyone help, please? :sob:SetA.txt (3.3 MB)

Hello @yukiii1223,

this one should do it:
yyyy-MM-dd HH:mm:ss[.SSSSSS]

Br,
Ivan

4 Likes

Hi lvan, i cannot find this format in String to Date Time node.

yyyy-MM-dd HH:mm:ss[.SSSSSS] Can be pasted in both String to date time nodes (normal and legacy)
image

3 Likes

Thank You soo much! It is working now! :blush: :blush:

1 Like

You already fixed it so just to add some additional thoughts here.I am sometimes lost with the various date format options so I try the palladian date extractor node and see whether that works. This could work for your case as well :wink:
best regards

1 Like

Okayyy sure, I will try later! Thank you for your advice! :blush:

Hello @yukiii1223,

glad you made it. Just to add that in String to Date&Time node you can write your own format. Drop down menu only contains most used and previously used formats.

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.