Re: ResultSet.getObject(..., LocalTime.class) not working with Postgres timetz type

Dave Cramer <[email protected]> Fri, 19 Apr 2019 09:36:42 -0400
Newsgroups gmane.comp.db.postgresql.jdbc
Message-ID <CADK3HH+x3NFPsFZ2fmKL8V0LHzsMaVpzXEg2TBjQMTk3vTeFdA@mail.gmail.com>
On Thu, 18 Apr 2019 at 13:19, Philippe Marschall <[email protected]> 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

>
>