Parsing date time using string to date

[srimalj]

Hi

I’m having trouble parsing a string such as ‘23/10/19 7:12:00 PM’ using string to date time.

I’ve used the format ‘dd/MM/yy hh:mm:ss A’ from the list but it says.

ERROR String to Date&Time 3:2 Execute failed: Failed to parse date in row 'Row0: Text ‘01/01/19 10:08:00 AM’ could not be parsed at index 18

Any help would be much appreciated

Thanks

[srimalj]

datetime_problem.knwf (7.6 KB)

I’ve attached my knime workflow here. Thanks

[mlauber71]

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:

Messy Date & Time String Reformatting

OK I did a combination of the format “MM/dd/yy HH:mm a” extract the hour if the hour is 12 or AM nothing is added if the hour is PM 12 hours are added a date time shift brings back the military/real hour I wonder why it would not work with the original format because Java should be able to do that. Please check the solution. We Europeans use to struggle with the AM/PM concept. [image] kn_example_messy_date_time.knwf (370.2 KB)

datetime_test.knwf (11.3 KB)

[ipazin]

Hi there @srimalj,

welcome to KNIME Community!

From node description you can see that:
capital letter A is for milli of day
and small a is for am/pm of day

Also take your hours range into consideration:

h: clock hour of am/pm (1-12)
K: hour of am/pm (0-11)
k: clock hour of am/pm (1-24)
H: hour of day (0-23)

Br,
Ivan