Postgres Pro
Downloads
Home   >   mailing lists

Error in JDBC 'Date and Time' docs - Mailing list pgsql-jdbc

From David Schmidt
Subject Error in JDBC 'Date and Time' docs
Date
Msg-id CAH6v9uHnaDq6jjVMTTBymzCCQRmM3vPvkcwCdPyOSbGNnSZkqQ@mail.gmail.com
Whole thread Raw
Responses Re: Error in JDBC 'Date and Time' docs  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List pgsql-jdbc
Tree view
Hi,

the docs at
https://jdbc.postgresql.org/documentation/head/8-date-time.html
tell me to use the OffsetTime class for TIMESTAMP WITH TIMEZONE.

Acording to my tests and the source, this is wrong and should be OffsetDateTime:

-David

pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Error in JDBC 'Date and Time' docs
Next
From: Vladimir Sitnikov
Date:
Subject: Re: ResultSet.getClob() causing problems when used with JPA's @Lob