Re: Bad timestamp external representation - Mailing list pgsql-general

From Tom Lane
Subject Re: Bad timestamp external representation
Date
Msg-id 28108.1038642227@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bad timestamp external representation  (Jim Worke <jimworke@inbox.lv>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ALTER TABLE & COLUMN
Next
From: Joel Burton
Date:
Subject: Re: SQL Query