Re: [HACKERS] timezone problem?

From: Paul Schulz <pauls(at)caemrad(dot)com(dot)au>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] timezone problem?
Date: 2000-01-21 05:58:43
Message-ID: 200001210558.QAA12751@caemrad.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)alumni(dot)caltech(dot)edu
> South Pasadena, California
>
> ************
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-01-21 06:09:57 Re: [HACKERS] pg_dump disaster
Previous Message Tom Lane 2000-01-21 05:51:51 Re: vacuum timings