[Bug]: Dateformats for JDBC Converters seem wrong

[vitoravancini]

Related Template(s)

JDBCto*

What happened?

Java docs states that minor case 'h' is for am/pm dates:

the JdbcConverter uses date format as such:

DateTimeFormatter.ofPattern("yyyy-MM-dd hh:mm:ss.SSSSSS");        

Default jdbc connections brings date columns in 0-23 hour format

a date like 2021-01-02 00:41:59 becomes 2021-01-02 12:41:59 and a date like 2021-12-30 14:51:10 becomes 2021-12-30 02:51:10

with no ampm signalization.

Beam Version

2.32.0

Relevant log output

No response