Re: Bad timestamp external representation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bad timestamp external representation
Дата
Msg-id 28108.1038642227@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bad timestamp external representation  (Jim Worke <jimworke@inbox.lv>)
Список pgsql-general
Jim Worke <jimworke@inbox.lv> writes:
> On Thursday 28 November 2002 8:35 am, Tom Lane wrote:
>> What do you think SGT is?

> I believe SGT is for Singapore time, no?

Okay, but what exactly is the offset from GMT?  And is there any
daylight-savings convention there?

Looking in the zic database, I find

# Singapore
# Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
Zone    Asia/Singapore    6:55:24 -    LMT    1880
            6:55:24    -    SMT    1905 Jun # Singapore Mean Time
            7:00    -    MALT    1933     # Malaya Time
            7:20    -    MALT    1942 Feb 15
            9:00    -    JST    1945 Sep  2
            7:20    -    MALT    1950
            7:30    -    MALT    1965 Aug  9 # independence
            7:30    -    SGT    1982 May # Singapore Time
            8:00    -    SGT

and no other entries defining "SGT".  So it seems it'd be reasonable to
define SGT as GMT+8, although strictly speaking this'd be incorrect for
years before 1982.

Comments?

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: ALTER TABLE & COLUMN
Следующее
От: Joel Burton
Дата:
Сообщение: Re: SQL Query