Skip site navigation (1) Skip section navigation (2)

Re: Java's set of timezone names

From: Vadim Nasardinov <vadimn(at)redhat(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Java's set of timezone names
Date: 2005-07-20 19:10:28
Message-ID: 200507201510.28661@vadim.nasardinov (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

In response to

Responses

pgsql-jdbc by date

Next:From: John R PierceDate: 2005-07-20 19:21:52
Subject: Re: Timestamp Conversion Woes Redux
Previous:From: Vadim NasardinovDate: 2005-07-20 18:58:39
Subject: Re: Timestamp Conversion Woes Redux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group