| 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: | Whole Thread | Raw Message | 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 |