From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | jimworke(at)inbox(dot)lv |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Bad timestamp external representation |
Date: | 2002-11-30 07:43:47 |
Message-ID: | 28108.1038642227@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jim Worke <jimworke(at)inbox(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Burton | 2002-11-30 07:45:44 | Re: SQL Query |
Previous Message | Alvaro Herrera | 2002-11-30 05:55:07 | Re: 7.4 Wishlist |