[Bug]: Wrong timestamp format template in Select transform

[maxbobse]

Apache Hop version?

2.15

Java version?

OpenJDK 64-Bit Server VM Temurin-21.0.3+9 (build 21.0.3+9-LTS, mixed mode, sharing)

Operating system

Windows

What happened?

The format "MM/dd/yyyy HH:mm:ss aa" leads to issues when converting strings to timestamps because HH implies that there can be a 23:00 AM which is not true.

Correct format should be 'MM/dd/yyyy hh:mm:ss aa'

See #5948 for more details.
Also, but here I am not sure, I believe having a single 'a' at the end to indicate AM/PM is sufficient.

Issue Priority

Priority: 3

Issue Component

Component: Transforms

[hansva]

.take-issue

[dmainou]

@hansva
May be worth pointing the documentation at this page for dateformats above and beyond Hop's list?

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

[hansva]

Yea, that might have to be referenced somewhere...