Re: Bad timestamp external representation

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