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
>
> ************
>
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 |