Re: [HACKERS] timezone problem? - Mailing list pgsql-hackers

From Paul Schulz
Subject Re: [HACKERS] timezone problem?
Date
Msg-id 200001210558.QAA12751@caemrad.com.au
Whole thread Raw
In response to Re: [HACKERS] timezone problem?  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
Has anyone noticed the following timezoning problem..

If a datetime variable is read out, and then inserted back in again
(verbatim) I get a change in the time value. I suspect that it because
out lime zona Australia/Adelaide is CST, which I belive is also an
American timezone.  Trimming the timezone info (CST) off, fixes this
problem.  Can anyone shed any light?

How does one get the +1030 timezone format?

PaulS
> > Maybe I'm going to check where the translation Japan -> JST has benn
> > actually done.
> 
> You will find it in the timezone file itself. Use "zdump" to look at
> the file of interest:
> 
> [root@golem zoneinfo]# zdump -v /usr/share/zoneinfo/Japan
> Japan  Fri Dec 13 20:45:52 1901 GMT = Sat Dec 14 05:45:52 1901 JST
> isdst=0
> Japan  Sat Dec 14 20:45:52 1901 GMT = Sun Dec 15 05:45:52 1901 JST
> isdst=0
> Japan  Mon Jan 18 03:14:07 2038 GMT = Mon Jan 18 12:14:07 2038 JST
> isdst=0
> Japan  Tue Jan 19 03:14:07 2038 GMT = Tue Jan 19 12:14:07 2038 JST
> isdst=0
> 
> Wow, that is a short set of rules! The PST8PDT file is 374 lines ;)
> 
>                   - Thomas
> 
> -- 
> Thomas Lockhart                lockhart@alumni.caltech.edu
> South Pasadena, California
> 
> ************
> 



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuum timings
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] pg_dump disaster