From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Timestamp without Timezone and differing client / server tzs |
Date: | 2008-07-09 04:36:46 |
Message-ID: | 4874405E.6030608@kensystem.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Oliver Jowett wrote:
> Ken Johanson wrote:
>
>> 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?
>
> You could change the client JVM's default timezone I suppose.
>
> I still don't understand exactly what you are trying to do, though.
>
To be sure, is the intent of the server's
timezone = UTC
config parameter, not to provide a hint to the clients about which
implicit timezone it treats zone-less strings as?
I have not dug in but am speculating that in the protocol some
indication of implicit tz may be provided.
Then again it may have no such intent at the client/connection level and
only be used for database date/time functions calculated against storage(?).
k
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2008-07-09 04:42:02 | Re: Timestamp without Timezone and differing client / server tzs |
Previous Message | Ken Johanson | 2008-07-09 04:31:08 | Re: Timestamp without Timezone and differing client / server tzs |