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

Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)

From: Vadim Nasardinov <vadimn(at)redhat(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)
Date: 2005-07-20 18:16:37
Message-ID: 200507201416.37925@vadim.nasardinov (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Wednesday 20 July 2005 13:41, Tom Lane wrote:
> Hmm ... does Java have a standard set of timezone names?  If so,
> does it bear any resemblance to the zic database names?

I'm not sure how Roedy Green knows this, but this is what he has to
say on the subject in his Java Glossary:

   http://www.mindprod.com/jgloss/timezone.html

   The names for timezones used in Java comes from a list maintained
   at NIH by Arthur David Olson. For reasons only he understands,
   Pacific Standard Time is called America/Los_Angeles.

As far as I can tell, Olson's timezone data can be found here:
  ftp://elsie.nci.nih.gov/pub/

Sun's JDK puts timezone data in $JAVA_HOME/jre/lib/zi/

Sun's JDK's timezone info seems fairly different from what, say,
Fedora Core distributes in its tzdata RPM:

 | $ find /usr/share/zoneinfo/ -type f -printf '%P\n' | sort > /tmp/linux-tzdata.txt 
 | $ find /usr/local/j2sdk1.4.2_08/jre/lib/zi -type f -printf '%P\n' | sort > /tmp/java-tzdata.txt 
 | $ diff /tmp/linux-tzdata.txt /tmp/java-tzdata.txt  | wc -l
 | 1309

In response to

Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2005-07-20 18:29:48
Subject: Re: Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)
Previous:From: Dave CramerDate: 2005-07-20 18:13:25
Subject: Re: Timestamp Conversion Woes Redux

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