Postgres Pro
Downloads
Home   >   mailing lists

Re: ResultSet.getObject(..., LocalTime.class) not working withPostgres timetz type - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: ResultSet.getObject(..., LocalTime.class) not working withPostgres timetz type
Date
Msg-id CADK3HH+x3NFPsFZ2fmKL8V0LHzsMaVpzXEg2TBjQMTk3vTeFdA@mail.gmail.com
Whole thread Raw
In response to Re: ResultSet.getObject(..., LocalTime.class) not working withPostgres timetz type  (Philippe Marschall <pm@netcetera.ch>)
Responses Re: ResultSet.getObject(..., LocalTime.class) not working withPostgres timetz type  (Philippe Marschall <pm@netcetera.ch>)
List pgsql-jdbc
Tree view


On Thu, 18 Apr 2019 at 13:19, Philippe Marschall <pm@netcetera.ch> wrote:
On 17.04.19 19:10, Dave Cramer wrote:
> Not everyone agrees with WITH TIMEZONE qnd it doesn't help that the
> server does not store the timezone

It is my understanding the server converts to UTC when storing and
returns UTC.

Yes, so the problem becomes what Timezone should we convert it to ? The server timezone, or the client timezone?

There are some that say only use without timezone, others say with. Depends on your application

Dave Cramer

pgsql-jdbc by date:

Previous
From: Adam Brusselback
Date:
Subject: [pgjdbc/pgjdbc] 0efcf8: Add method alias's for each property whichdidn't ...
Next
From: Andrew Guibert
Date:
Subject: [pgjdbc/pgjdbc] fac5e0: Fix inconsistent javadoc forsetDefaultAutoCommit ...