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

From Kris Jurka
Subject Re: Timestamp Conversion Woes Redux
Date
Msg-id Pine.BSO.4.56.0507201450060.19284@leary.csoft.net
Whole thread Raw
In response to Re: Timestamp Conversion Woes Redux  (John R Pierce <pierce@hogranch.com>)
Responses Re: Timestamp Conversion Woes Redux  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc

On Wed, 20 Jul 2005, John R Pierce wrote:

> as we discovered the hard way, named timezones are a BAD IDEA.     We had some
> stuff in java + jdbc + postgres that used a timezone, when it was brought up in
> Singapore, their local timezone memnonic wasn't recognized by postgres, and
> when it was brought up in China, CST was misinterpretted as Central Standard
> Time rather than China Standard Time (about 12 hours off)
>

No, this indicates that *abbreviated* timezones are a bad idea, not named
timezones.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Java's set of timezone names
Next
From: Dave Cramer
Date:
Subject: Re: Timestamp Conversion Woes Redux