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

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: Philippe Marschall <pm(at)netcetera(dot)ch>
Cc: pgsql-jdbc(at)lists(dot)postgresql(dot)org, Mark Rotteveel <mark(at)lawinegevaar(dot)nl>
Subject: Re: ResultSet.getObject(..., LocalTime.class) not working with Postgres timetz type
Date: 2019-04-19 13:36:42
Message-ID: CADK3HH+x3NFPsFZ2fmKL8V0LHzsMaVpzXEg2TBjQMTk3vTeFdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 18 Apr 2019 at 13:19, Philippe Marschall <pm(at)netcetera(dot)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

>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andrew Guibert 2019-04-19 13:54:03 [pgjdbc/pgjdbc] fac5e0: Fix inconsistent javadoc for setDefaultAutoCommit ...
Previous Message Adam Brusselback 2019-04-19 10:11:32 [pgjdbc/pgjdbc] 0efcf8: Add method alias's for each property which didn't ...