From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Thomas Lockhart <thomas(at)fourpalms(dot)org> |
Cc: | PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: More time zones |
Date: | 2002-02-25 18:30:10 |
Message-ID: | 200202251830.g1PIUAs25613@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This is related to the Australian timezone duplication where we have a
GUC parameter. Could we generalize the GUC stuff to allow arbitrary
timezone mappings? Just an idea. Not sure it is worth it. The
Australians complained but I have not hear complaints from other
countries.
---------------------------------------------------------------------------
Thomas Lockhart wrote:
> I've added a fairly large number of time zones to the date/time parser.
> They were originally mentioned in my zinc time zone database but without
> sufficient information to actually enable them. Ruslan gave me a
> reference to a web site with more time zone details so I was able to
> fill in quite a few of them.
>
> I've committed the changes to the development tree, and to the stable
> tree also.
>
> Details below. Comments and complaints welcome ;)
>
> - Thomas
>
> There are newly recognized time zones:
>
> AMST AMT ANAST ANAT ART AZOST AZOT AZST AZT BNT BORT BOT BRA BTT
> CHADT CHAST CKT CLST CLT COT CVT DAVT DDUT EEST EGST EGT
> FJST FJT FKST FKT GALT GAMT GEST GET GFT GILT GYT
> HKT ICT IRKST IRKT IRT JAVT JAYT KDT KGST KGT KOST KRAST KRAT
> LHDT LHST LINT LKT MAGST MAGT MART MMT MPT MSD MSK MYT NCT
> NOVST NOVT NUT OMSST OMST
> PET PETST PETT PGT PHOT PHT PKT PMDT PONT PWT PYST PYT
> THAT TJT TKT TMT TOT TRUK TVT ULAST ULAT UYST UYT UZST UZT
> VET VLAST VLAT VUT WAKT WEST WFT WGST WGT WST
> YAKST YAKT YAPT YEKST YEKT
>
> There are a few with multiple definitions for which I chose one (the
> alternates are in parens):
>
> BST British (Brazil, Bering)
> CCT China Coast (Cocos)
> EAST Easter Island (Indian Antananarivo Savings Time)
> EAT East Africa (Indian Antananarivo Time)
>
> And a few others with multiple definitions for which I did not make a
> choice and left all unrecognized:
>
> AST Atlantic, Arabia, Acre
> ECT
> IDT Israeli, Iran, Indian Daylight Time
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-02-25 18:31:16 | Re: Open magazine article on open source rdbms |
Previous Message | GB Clark | 2002-02-25 18:02:17 | Re: [HACKERS] Nice Oracle tuning article |