Re: Timestamp without Timezone and differing client / server tzs

Поиск
Список
Период
Сортировка
От Ken Johanson
Тема Re: Timestamp without Timezone and differing client / server tzs
Дата
Msg-id 487439D8.2050508@kensystem.com
обсуждение исходный текст
Ответ на Re: Timestamp without Timezone and differing client / server tzs  (Oliver Jowett <oliver@opencloud.com>)
Ответы Re: Timestamp without Timezone and differing client / server tzs
Список pgsql-jdbc
Oliver Jowett wrote:
> Ken Johanson wrote:
>
>> Question: with ts without tz storage, should not a timestamp be
>> normalized to the  servers implicit TZ (UTC in this case), since that
>> is set in the config's client-tz?
>
> If you don't specify a Calendar to setTimestamp, it's assumed you mean
> the client JVM's default timezone (the same timezone that
> Timestamp.toString() assumes).

.......

> If you want to interpret a Timestamp as being in a particular timezone,
> use the getTimestamp()/setTimestamp() variants that take an explicit
> Calendar.

So, short of passing a calendar to setTimezone, there is no other way to
indicate to the driver that zone-less date/time type values should be
translated to the server's different timezone, is this correct?

k



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Scott Langley
Дата:
Сообщение: Patch to allow setting schema/search_path in the connectionURL
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Timestamp without Timezone and differing client / server tzs