java.sql.ResultSet.getTime() returns wrong time
От | Lukas Eder |
---|---|
Тема | java.sql.ResultSet.getTime() returns wrong time |
Дата | |
Msg-id | AANLkTinN6yX+=Wz+iZzsnWZhp4+bNfA7uRB+RoHsyoof@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: java.sql.ResultSet.getTime() returns wrong time
|
Список | pgsql-jdbc |
I have experienced a very peculiar issue with the postgresql JDBC driver when calling java.sql.ResultSet.getTime() or getTimestamp() on a field of type timetz.
Here is how to reproduce the issue:
http://archives.postgresql.org/pgsql-jdbc/2010-05/msg00041.php
Cheers,
Lukas
Here is how to reproduce the issue:
- Set date and time to 2010-09-19 14:57:00 CEST (central european summer time: UTC+2) or something similar
- Fetch "SELECT current_time" from the Postgres database directly. This will return the correct time, e.g "14:57:17.116452+02"
- Fetch "SELECT current_time" from the Postgres JDBC driver. This will return a wrong time, e.g 13:57:17
http://archives.postgresql.org/pgsql-jdbc/2010-05/msg00041.php
Cheers,
Lukas
В списке pgsql-jdbc по дате отправления: