Re: More time zones

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

In response to

Responses

Browse pgsql-hackers by date

  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