Re: More time zones - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: More time zones
Date
Msg-id 200202251830.g1PIUAs25613@candle.pha.pa.us
Whole thread Raw
In response to More time zones  (Thomas Lockhart <thomas@fourpalms.org>)
Responses Re: More time zones  (Peter Eisentraut <peter_e@gmx.net>)
List 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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: decode()
Next
From: Bruce Momjian
Date:
Subject: Re: Open magazine article on open source rdbms