Re: Timestamp without Timezone and differing client / server tzs

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

In response to

Responses

Browse pgsql-jdbc by date

  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