Re: Timezone discrepancies

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Timezone discrepancies
Дата
Msg-id Pine.LNX.4.21.0009202038380.362-100000@peter
обсуждение исходный текст
Ответ на Re: Timezone discrepancies  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список pgsql-hackers
Thomas Lockhart writes:

> > ERROR:  Bad timestamp external representation '1-1-2000 00:00:00 DST'
> > ERROR:  Bad timestamp external representation '1-1-2000 00:00:00 ZP4'
> > ERROR:  Bad timestamp external representation '1-1-2000 00:00:00 ZP5'
> > ERROR:  Bad timestamp external representation '1-1-2000 00:00:00 ZP6'
> 
> DST - this is a docs error. DNT is the correct form for "Dansk Normal
> Tid", and "DST" is a "Daylight Savings Time" qualifier for other time
> zones. Will fix.

Another comment: I just peeked and, to be blunt, the time zone database
looks like a mess. For example, there's CET (central european time), but
not CEST (central european summer time). Instead there's CETDST, which
I've never heard used. Then there's MEST, MET, METDST, MEWT, MEZ, all of
which are supposed to be "Middle Europe" variations, none of which I've
ever heard of. (MEZ and MESZ are the German translations of CET and CEST,
but as listed they claim to be English terms.) Also I've never heard of
"Dansk Normal Tid" (DNT) or "Swedish Summer Time" (SST), both of these
places use Central European Time.

There are several other obscure candidates where I don't have direct
geographic knowledge, such as "Moluccas Time" (MT, I though that would be
Mountain Time), or "Seychelles Time" (SET).

Probably sometime in the near future a discussion and some research ought
to take place to sort out this list.


-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Weird Tcl/Tk configuration
Следующее
От: Gunnar R|nning
Дата:
Сообщение: Re: Timezone discrepancies