trouble with hour string to date time

[nobaj]

Hi I have some troubles, the format does not work, I don’t se what I am doing wrong

[mlauber71]

@nobaj you might very well have to convert the “a.m.” and “p.m.” into AM and PM with the Column Expression node

replace(replace(column("time_str"),"a.m." , "AM"),"p.m.", "PM")

then something like

hh:mm:ss a

https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html

[nobaj]

Still not working :C

[mlauber71]

@nobaj well now you do not have any seconds but the pattern suggest you have. So you might have to come up with a consistent string or edit them beforehand or you might make seconds optional. And you might want to use just “en” as Locale

hh:mm[:ss] a

Java Pattern for time format with AM / PM and flexible seconds – mlauber71

[nobaj]

I have tried that and did not work, change the locale to “en-US” and everything work like a charm, do you know what happened there? I mean, numbers has no language right?