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