New Zealand - TZ change - Mailing list pgsql-patches
| From | Zdenek Kotala |
|---|---|
| Subject | New Zealand - TZ change |
| Date | |
| Msg-id | 467F9AEF.9030408@sun.com Whole thread Raw |
| Responses |
Re: New Zealand - TZ change
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] New Zealand - TZ change (Bruce Momjian <bruce@momjian.us>) |
| List | pgsql-patches |
I would like to inform, that New Zealand changed DST rules and new timezone files are available. See http://www.dia.govt.nz/diawebsite.nsf/wpg_URL/Services-Daylight-Saving-Daylight-saving-to-be-extended Patch for head attached. I kept zic.c untouched, but I think it would be nice to update it as well. Are there any updated release scheduled 8.0-8.2? Zdenek ? tz.diff Index: src/timezone/data/africa =================================================================== RCS file: /projects/cvsroot/pgsql/src/timezone/data/africa,v retrieving revision 1.5 diff -c -r1.5 africa *** src/timezone/data/africa 19 Apr 2007 22:44:32 -0000 1.5 --- src/timezone/data/africa 25 Jun 2007 10:26:50 -0000 *************** *** 1,4 **** ! # @(#)africa 8.7 # <pre> # This data is by no means authoritative; if you think you know better, --- 1,4 ---- ! # @(#)africa 8.8 # <pre> # This data is by no means authoritative; if you think you know better, *************** *** 416,421 **** --- 416,435 ---- # Namibia # The 1994-04-03 transition is from Shanks & Pottenger. # Shanks & Pottenger report no DST after 1998-04; go with IATA. + + # From Petronella Sibeene (2007-03-30) in + # <http://allafrica.com/stories/200703300178.html>: + # While the entire country changes its time, Katima Mulilo and other + # settlements in Caprivi unofficially will not because the sun there + # rises and sets earlier compared to other regions. Chief of + # Forecasting Riaan van Zyl explained that the far eastern parts of + # the country are close to 40 minutes earlier in sunrise than the rest + # of the country. + # + # From Paul Eggert (2007-03-31): + # Apparently the Caprivi Strip informally observes Botswana time, but + # we have no details. In the meantime people there can use Africa/Gaborone. + # RULE NAME FROM TO TYPE IN ON AT SAVE LETTER/S Rule Namibia 1994 max - Sep Sun>=1 2:00 1:00 S Rule Namibia 1995 max - Apr Sun>=1 2:00 0 - Index: src/timezone/data/australasia =================================================================== RCS file: /projects/cvsroot/pgsql/src/timezone/data/australasia,v retrieving revision 1.5 diff -c -r1.5 australasia *** src/timezone/data/australasia 19 Apr 2007 22:44:32 -0000 1.5 --- src/timezone/data/australasia 25 Jun 2007 10:26:51 -0000 *************** *** 1,4 **** ! # @(#)australasia 8.6 # <pre> # This file also includes Pacific islands. --- 1,4 ---- ! # @(#)australasia 8.7 # <pre> # This file also includes Pacific islands. *************** *** 348,357 **** Rule Chatham 1976 1989 - Mar Sun>=1 2:45s 0 S Rule NZ 1989 only - Oct Sun>=8 2:00s 1:00 D Rule Chatham 1989 only - Oct Sun>=8 2:45s 1:00 D ! Rule NZ 1990 max - Oct Sun>=1 2:00s 1:00 D ! Rule Chatham 1990 max - Oct Sun>=1 2:45s 1:00 D ! Rule NZ 1990 max - Mar Sun>=15 2:00s 0 S ! Rule Chatham 1990 max - Mar Sun>=15 2:45s 0 S # Zone NAME GMTOFF RULES FORMAT [UNTIL] Zone Pacific/Auckland 11:39:04 - LMT 1868 Nov 2 11:30 NZ NZ%sT 1946 Jan 1 --- 348,361 ---- Rule Chatham 1976 1989 - Mar Sun>=1 2:45s 0 S Rule NZ 1989 only - Oct Sun>=8 2:00s 1:00 D Rule Chatham 1989 only - Oct Sun>=8 2:45s 1:00 D ! Rule NZ 1990 2006 - Oct Sun>=1 2:00s 1:00 D ! Rule Chatham 1990 2006 - Oct Sun>=1 2:45s 1:00 D ! Rule NZ 1990 2007 - Mar Sun>=15 2:00s 0 S ! Rule Chatham 1990 2007 - Mar Sun>=15 2:45s 0 S ! Rule NZ 2007 max - Sep lastSun 2:00s 1:00 D ! Rule Chatham 2007 max - Sep lastSun 2:45s 1:00 D ! Rule NZ 2008 max - Apr Sun>=1 2:00s 0 S ! Rule Chatham 2008 max - Apr Sun>=1 2:45s 0 S # Zone NAME GMTOFF RULES FORMAT [UNTIL] Zone Pacific/Auckland 11:39:04 - LMT 1868 Nov 2 11:30 NZ NZ%sT 1946 Jan 1 *************** *** 1146,1151 **** --- 1150,1161 ---- # transitions at 2:45 local standard time; this confirms that Chatham # is always exactly 45 minutes ahead of Auckland. + # From Colin Sharples (2007-04-30): + # DST will now start on the last Sunday in September, and end on the + # first Sunday in April. The changes take effect this year, meaning + # that DST will begin on 2007-09-30 2008-04-06. + # http://www.dia.govt.nz/diawebsite.nsf/wpg_URL/Services-Daylight-Saving-Daylight-saving-to-be-extended + ############################################################################### Index: src/timezone/data/northamerica =================================================================== RCS file: /projects/cvsroot/pgsql/src/timezone/data/northamerica,v retrieving revision 1.7 diff -c -r1.7 northamerica *** src/timezone/data/northamerica 19 Apr 2007 22:44:32 -0000 1.7 --- src/timezone/data/northamerica 25 Jun 2007 10:26:54 -0000 *************** *** 1,4 **** ! # @(#)northamerica 8.16 # <pre> # also includes Central America and the Caribbean --- 1,4 ---- ! # @(#)northamerica 8.17 # <pre> # also includes Central America and the Caribbean *************** *** 2325,2330 **** --- 2325,2333 ---- # # The reason seems to be an energy crisis. + # From Stephen Colebourne (2007-02-22): + # Some IATA info: Haiti won't be having DST in 2007. + # Rule NAME FROM TO TYPE IN ON AT SAVE LETTER/S Rule Haiti 1983 only - May 8 0:00 1:00 D *************** *** 2334,2341 **** # Go with IATA. Rule Haiti 1988 1997 - Apr Sun>=1 1:00s 1:00 D Rule Haiti 1988 1997 - Oct lastSun 1:00s 0 S ! Rule Haiti 2005 max - Apr Sun>=1 0:00 1:00 D ! Rule Haiti 2005 max - Oct lastSun 0:00 0 S # Zone NAME GMTOFF RULES FORMAT [UNTIL] Zone America/Port-au-Prince -4:49:20 - LMT 1890 -4:49 - PPMT 1917 Jan 24 12:00 # P-a-P MT --- 2337,2344 ---- # Go with IATA. Rule Haiti 1988 1997 - Apr Sun>=1 1:00s 1:00 D Rule Haiti 1988 1997 - Oct lastSun 1:00s 0 S ! Rule Haiti 2005 2006 - Apr Sun>=1 0:00 1:00 D ! Rule Haiti 2005 2006 - Oct lastSun 0:00 0 S # Zone NAME GMTOFF RULES FORMAT [UNTIL] Zone America/Port-au-Prince -4:49:20 - LMT 1890 -4:49 - PPMT 1917 Jan 24 12:00 # P-a-P MT *************** *** 2518,2530 **** -4:00 - AST # Turks and Caicos ! # From Paul Eggert (2006-03-22): # Shanks & Pottenger say they use US DST rules, but IATA SSIM (1991/1998) ! # says they switch at midnight. Go with IATA SSIM. # Rule NAME FROM TO TYPE IN ON AT SAVE LETTER/S ! Rule TC 1979 1986 - Apr lastSun 0:00 1:00 D ! Rule TC 1979 max - Oct lastSun 0:00 0 S ! Rule TC 1987 max - Apr Sun>=1 0:00 1:00 D # Zone NAME GMTOFF RULES FORMAT [UNTIL] Zone America/Grand_Turk -4:44:32 - LMT 1890 -5:07:12 - KMT 1912 Feb # Kingston Mean Time --- 2521,2551 ---- -4:00 - AST # Turks and Caicos ! # ! # From Chris Dunn in ! # <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=415007> ! # (2007-03-15): In the Turks & Caicos Islands (America/Grand_Turk) the ! # daylight saving dates for time changes have been adjusted to match ! # the recent U.S. change of dates. ! # ! # From Brian Inglis (2007-04-28): ! # http://www.turksandcaicos.tc/calendar/index.htm [2007-04-26] ! # there is an entry for Nov 4 "Daylight Savings Time Ends 2007" and three ! # rows before that there is an out of date entry for Oct: ! # "Eastern Standard Times Begins 2007 ! # Clocks are set back one hour at 2:00 a.m. local Daylight Saving Time" ! # indicating that the normal ET rules are followed. ! # ! # From Paul Eggert (2006-05-01): # Shanks & Pottenger say they use US DST rules, but IATA SSIM (1991/1998) ! # says they switch at midnight. Go with Shanks & Pottenger. ! # # Rule NAME FROM TO TYPE IN ON AT SAVE LETTER/S ! Rule TC 1979 1986 - Apr lastSun 2:00 1:00 D ! Rule TC 1979 2006 - Oct lastSun 2:00 0 S ! Rule TC 1987 2006 - Apr Sun>=1 2:00 1:00 D ! Rule TC 2007 max - Mar Sun>=8 2:00 1:00 D ! Rule TC 2007 max - Nov Sun>=1 2:00 0 S # Zone NAME GMTOFF RULES FORMAT [UNTIL] Zone America/Grand_Turk -4:44:32 - LMT 1890 -5:07:12 - KMT 1912 Feb # Kingston Mean Time
pgsql-patches by date: