Postgres Pro
Downloads
Home   >   mailing lists

Re: Java's set of timezone names - Mailing list pgsql-jdbc

From Vadim Nasardinov
Subject Re: Java's set of timezone names
Date
Msg-id 200507201510.28661@vadim.nasardinov
Whole thread Raw
In response to Re: Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Java's set of timezone names  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view 
On Wednesday 20 July 2005 14:57, Dave Cramer wrote:
> On my Mac my java timezone was set to Canada/Montreal which was
> broken (did not use DST ) and the server certainly doesn't
> understand it.

Out of curiosity, do you remember which JDK had this timezone?
Sun's JDK on Linux doesn't have it:

 | $ find /usr/local/j2sdk1.4.2_08/jre/lib/zi/ -name Montreal
 | /usr/local/j2sdk1.4.2_08/jre/lib/zi/America/Montreal

It only has America/Montreal, which PostgreSQL should grok just fine,
AFAICT:

 | $ find /usr/share/zoneinfo/ -name Montreal
 | /usr/share/zoneinfo/right/America/Montreal
 | /usr/share/zoneinfo/posix/America/Montreal
 | /usr/share/zoneinfo/America/Montreal

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)
Next
From: John R Pierce
Date:
Subject: Re: Timestamp Conversion Woes Redux