Re: [HACKERS] timezone problem?
От | Paul Schulz |
---|---|
Тема | Re: [HACKERS] timezone problem? |
Дата | |
Msg-id | 200001210558.QAA12751@caemrad.com.au обсуждение исходный текст |
Ответ на | Re: [HACKERS] timezone problem? (Thomas Lockhart <lockhart@alumni.caltech.edu>) |
Список | 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 по дате отправления: