Home   >   mailing lists

Thread: Error in JDBC 'Date and Time' docs

Error in JDBC 'Date and Time' docs

From

David Schmidt

Date:

28 July 2016, 14:08:46

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:

https://github.com/pgjdbc/pgjdbc/blob/17b1334a55b96f125f650e15f329ab036430ed4d/pgjdbc/src/main/java/org/postgresql/jdbc/PgPreparedStatement.java#L1046

-David

Re: Error in JDBC 'Date and Time' docs

From

Vladimir Sitnikov

Date:

28 July 2016, 14:43:34

>https://jdbc.postgresql.org/documentation/head/8-date-time.html

>tell me to use the OffsetTime class for TIMESTAMP WITH TIMEZONE.

Nice catch. Would you volunteer to update the docs?

Here's the relevant file: https://github.com/pgjdbc/www/blob/9c26d575dac8e3014fff29cf05b1e88ae322e481/documentation/head/8-date-time.md

It looks like "time with time zone" is missing in the table

Vladimir

Re: Error in JDBC 'Date and Time' docs

From

Vladimir Sitnikov

Date:

28 July 2016, 17:43:19

>https://jdbc.postgresql.org/documentation/head/8-date-time.html

>tell me to use the OffsetTime class for TIMESTAMP WITH TIMEZONE.

Nice catch. Would you volunteer to update the docs?

Here's the relevant file: https://github.com/pgjdbc/www/blob/9c26d575dac8e3014fff29cf05b1e88ae322e481/documentation/head/8-date-time.md

It looks like "time with time zone" is missing in the table

Vladimir