Re: Timestamp Conversion Woes Redux - Mailing list pgsql-jdbc

From Christian Cryder
Subject Re: Timestamp Conversion Woes Redux
Date
Msg-id 90876a9e05072013444dc524ad@mail.gmail.com
Whole thread Raw
In response to Re: Timestamp Conversion Woes Redux  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Timestamp Conversion Woes Redux  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
On 7/20/05, Dave Cramer <pg@fastcrypt.com> wrote:
> I think using the same time zone as the server is the only way to go:

How does this prevent the DST munging issue, where a zoneless time
(eg. 04-03-2005 1:22 AM) is read from the DB and then re-written? What
is to keep it being from being rewritten as 2:22 AM?

> Kris has proposed a patch which would set the servers time zone to
> the JVM when the connection is started

What happens when someone writes a client server app, and one client
connects from timezone A, and another client connects from timezone B,
and the server itself is running in timezone C?

Christian

pgsql-jdbc by date:

Previous
From: Vadim Nasardinov
Date:
Subject: Re: Java's set of timezone names
Next
From: Christian Cryder
Date:
Subject: Custom types in Postgres, JDBC