Basic date time conversion

[mlauber71]

You might have to choose the format by hand and if this does not work to do additional conversions discussed here:

Messy Date & Time String Reformatting

Have you tried the string to Date/Time conversion with this format which should cover AM and PM dd/MM/yyyy hh.mm aa I think the node can also auto guess the right format. Also you can refer to.: https://www.knime.com/blog/the-new-date-time-integration I am not at my trusted machine right now so I can’t test it.

Extract time with PM/AM

Hi, I think the format h:mm' 'a should work for you. Kind regards Alexander

Parsing date time using string to date

I changed the format to: dd/MM/yy hh:mm:ss a and now it seems to work We had a similar discussion before and I came up with a little bit of a messy solution. Maybe as an inspiration if further problems occur: datetime_test.knwf (11.3 KB)

Maybe KNIME can improve the date and time nodes to handle these am/pm formats better.