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

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: ResultSet.getObject(..., LocalTime.class) not working withPostgres timetz type
Дата
Msg-id CADK3HH+x3NFPsFZ2fmKL8V0LHzsMaVpzXEg2TBjQMTk3vTeFdA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ResultSet.getObject(..., LocalTime.class) not working withPostgres timetz type  (Philippe Marschall <pm@netcetera.ch>)
Ответы Re: ResultSet.getObject(..., LocalTime.class) not working withPostgres timetz type  (Philippe Marschall <pm@netcetera.ch>)
Список pgsql-jdbc
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: [pgjdbc/pgjdbc] 0efcf8: Add method alias's for each property whichdidn't ...
Следующее
От: Andrew Guibert
Дата:
Сообщение: [pgjdbc/pgjdbc] fac5e0: Fix inconsistent javadoc forsetDefaultAutoCommit ...