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 20:20:41
Message-ID: 200507201620.41623@vadim.nasardinov (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Wednesday 20 July 2005 15:42, Dave Cramer wrote:
> I think as John pointed out though there are some issues with using
> named TimeZones.

Kris rebutted that comment.

> Is there a way to get the servers timezone info from the server ?

Good question.

Based upon a very cursory reading of the documentation, it seems to be
that PostgreSQL uses a hardcoded internal list of time zones for
dealing with timezone *input*, but it uses the underlying OS's
facilities for dealing with timezone *output*.  But then again, the
docs seems to have changed between 7.4 and 8.0.  For example, in 7.4:

  http://www.postgresql.org/docs/7.4/static/datatype-datetime.html

  PostgreSQL uses your operating system's underlying features to
  provide output time-zone support,

However, this sentence seems missing from 8.0:

  http://www.postgresql.org/docs/8.0/static/datatype-datetime.html

The docs for 7.4 provide a list of timezone abbreviations that
PostgreSQL recognizes:

  http://www.postgresql.org/docs/7.4/static/datetime-keywords.html

The 8.0 docs, too, provide the list of abbreviations but also a list
of unabbreviated timezone names:

  http://www.postgresql.org/docs/8.0/static/datetime-keywords.html
  
These seem to be hardcoded.

In response to

Responses

pgsql-jdbc by date

Next:From: Christian CryderDate: 2005-07-20 20:44:37
Subject: Re: Timestamp Conversion Woes Redux
Previous:From: Dave CramerDate: 2005-07-20 20:14:09
Subject: Re: Timestamp Conversion Woes Redux

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