Mark Rotteveel schrieb am 21.04.2020 um 11:02:
> Note that JDBC itself doesn't define support for java.sql.Time (or
> java.time.LocalTime) for time with time zone types (instead it maps
> to java.time.OffsetTime).
I know that JDBC doesn't support that (and I mentioned the thread were that was discussed previously) but I would
expectthe driver to at least return a value that is correct.
The interesting thing is, that if I use ResultSet.getString() on that column I do get the correct "value", e.g. the
following:
ResultSet rs = stmt.executeQuery("select current_time");
rs.next();
System.out.println("getString: " + rs.getString(1));
System.out.println("getTime: " + rs.getTime(1));
will print (when run at 12:26:08):
getString: 12:26:08.275455+02
getTime: 11:26:08
So at some point the driver does get the correct time, but the conversion to a java.sql.Time seems to lose one hour
somewhere.
Thomas