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 > >