Skip to content

Commit 40ce24c

Browse files
tglsfdctglsfdc
committed
Update time zone abbreviation lists for changes missed since 2006.
Most (all?) of Russia has moved to what's effectively year-round daylight savings time, so that the "standard" zone names now mean an hour later than they used to. Update that, notably changing MSK as per recent complaint from Sergey Konoplev, but also CHOT, GET, IRKT, KGT, KRAT, MAGT, NOVT, OMST, VLAT, YAKT, YEKT. The corresponding DST abbreviations are presumably now obsolete, but I left them in place with their old definitions, just to reduce any possible breakage from this change. Also add VOLT (Europe/Volgograd), which for some reason we never had before, as well as MIST (Antarctica/Macquarie), and fix obsolete definitions of MAWT, TKT, and WST.
1 parent 716bcb6 commit 40ce24c

File tree

14 files changed

+76
-68
lines changed

14 files changed

+76
-68
lines changed

‎src/timezone/tznames/Africa.txt

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Africa.txt,v 1.3 2009/09/06 15:25:23 tgl Exp $
7+
# src/timezone/tznames/Africa.txt
88
#
99

1010
CAT 7200 # Central Africa Time

‎src/timezone/tznames/America.txt

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/America.txt,v 1.4 2008/03/02 00:10:22 tgl Exp $
7+
# src/timezone/tznames/America.txt
88
#
99

1010
# Acre time is sometimes called Acre Standard Time (AST) which leads to a

‎src/timezone/tznames/Antarctica.txt

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Antarctica.txt,v 1.2 2006/07/25 13:49:21 tgl Exp $
7+
# src/timezone/tznames/Antarctica.txt
88
#
99

1010
CLST -10800 D # Chile Summer Time
@@ -17,8 +17,10 @@ DAVT 25200 # Davis Time (Antarctica)
1717
# (Antarctica/Davis)
1818
DDUT 36000 # Dumont-d`Urville Time (Antarctica)
1919
# (Antarctica/DumontDUrville)
20-
MAWT 21600 # Mawson Time (Antarctica)
20+
MAWT 18000 # Mawson Time (Antarctica) (caution: this used to mean 21600)
2121
# (Antarctica/Mawson)
22+
MIST 39600 # Macquarie Island Time
23+
# (Antarctica/Macquarie)
2224
NZDT 46800 D # New Zealand Daylight Time
2325
# (Antarctica/McMurdo)
2426
# (Pacific/Auckland)

‎src/timezone/tznames/Asia.txt

Lines changed: 24 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Asia.txt,v 1.5 2010/05/11 22:36:52 tgl Exp $
7+
# src/timezone/tznames/Asia.txt
88
#
99

1010
# CONFLICT! ADT is not unique
@@ -63,9 +63,9 @@ BORT 28800 # Borneo Time (Indonesia) (not in zic)
6363
BTT 21600 # Bhutan Time
6464
# (Asia/Thimphu)
6565
CCT 28800 # China Coastal Time (not in zic)
66-
CHOST 36000 D # Choibalsan Summer Time
66+
CHOST 36000 D # Choibalsan Summer Time (obsolete)
6767
# (Asia/Choibalsan)
68-
CHOT 32400 # Choibalsan Time
68+
CHOT 28800 # Choibalsan Time (caution: this used to mean 32400)
6969
# (Asia/Choibalsan)
7070
CIT 28800 # Central Indonesia Time
7171
# (Asia/Makassar)
@@ -118,9 +118,9 @@ EET 7200 # East-Egypt Time
118118
# (Europe/Zaporozhye)
119119
EIT 32400 # East Indonesia Time
120120
# (Asia/Jayapura)
121-
GEST 14400 D # Georgia Summer Time (there was a timezone change in 2004)
121+
GEST 14400 D # Georgia Summer Time (obsolete)
122122
# (Asia/Tbilisi)
123-
GET 10800 # Georgia Time (there was a timezone change in 2004)
123+
GET 14400 # Georgia Time (caution: this used to mean 10800)
124124
# (Asia/Tbilisi)
125125
# CONFLICT! GST is not unique
126126
# Other timezones:
@@ -141,9 +141,9 @@ ICT 25200 # Indochina Time
141141
IDT 10800 D # Israel Daylight Time
142142
IRDT 16200 D # Iran Daylight Time
143143
# (Asia/Tehran)
144-
IRKST 32400 D # Irkutsk Summer Time
144+
IRKST 32400 D # Irkutsk Summer Time (obsolete)
145145
# (Asia/Irkutsk)
146-
IRKT 28800 # Irkutsk Time
146+
IRKT 32400 # Irkutsk Time (caution: this used to mean 28800)
147147
# (Asia/Irkutsk)
148148
IRST 12600 # Iran Standard Time
149149
# (Asia/Tehran)
@@ -163,44 +163,44 @@ JAYT 32400 # Jayapura Time (Indonesia) (not in zic)
163163
JST 32400 # Japan Standard Time
164164
# (Asia/Tokyo)
165165
KDT 36000 D # Korean Daylight Time (not in zic)
166-
KGST 21600 D # Kyrgyzstan Summer Time
166+
KGST 21600 D # Kyrgyzstan Summer Time (obsolete)
167167
# (Asia/Bishkek)
168-
KGT 18000 # Kyrgyzstan Time
168+
KGT 21600 # Kyrgyzstan Time (caution: this used to mean 18000)
169169
# (Asia/Bishkek)
170-
KRAST 28800 D # Krasnoyarsk Summer Time
170+
KRAST 28800 D # Krasnoyarsk Summer Time (obsolete)
171171
# (Asia/Krasnoyarsk)
172-
KRAT 25200 # Krasnoyarsk Time
172+
KRAT 28800 # Krasnoyarsk Time (caution: this used to mean 25200)
173173
# (Asia/Krasnoyarsk)
174174
KST 32400 # Korean Standard Time
175175
# (Asia/Pyongyang)
176176
LKT 21600 # Lanka Time
177177
# (Asia/Colombo)
178-
MAGST 43200 D # Magadan Summer Time
178+
MAGST 43200 D # Magadan Summer Time (obsolete)
179179
# (Asia/Magadan)
180-
MAGT 39600 # Magadan Time
180+
MAGT 43200 # Magadan Time (caution: this used to mean 39600)
181181
# (Asia/Magadan)
182182
MMT 23400 # Myanmar Time
183183
# (Asia/Rangoon)
184184
MYT 28800 # Malaysia Time
185185
# (Asia/Kuala_Lumpur)
186186
# (Asia/Kuching)
187-
NOVST 25200 D # Novosibirsk Summer Time
187+
NOVST 25200 D # Novosibirsk Summer Time (obsolete)
188188
# (Asia/Novosibirsk)
189-
NOVT 21600 # Novosibirsk Time
189+
NOVT 25200 # Novosibirsk Time (caution: this used to mean 21600)
190190
# (Asia/Novosibirsk)
191191
NPT 20700 # Nepal Time
192192
# (Asia/Katmandu)
193-
OMSST 25200 D # Omsk Summer Time
193+
OMSST 25200 D # Omsk Summer Time (obsolete)
194194
# (Asia/Omsk)
195-
OMST 21600 # Omsk Time
195+
OMST 25200 # Omsk Time (caution: this used to mean 21600)
196196
# (Asia/Omsk)
197197
ORAT 18000 # Oral Time
198198
# (Asia/Oral)
199199
PETST 46800 D # Petropavlovsk-Kamchatski Summer Time
200200
# (Asia/Kamchatka)
201201
PETT 43200 # Petropavlovsk-Kamchatski Time
202202
# (Asia/Kamchatka)
203-
PHT 28800 # Phillipine Time (not in zic)
203+
PHT 28800 # Philippine Time (not in zic)
204204
PKT 18000 # Pakistan Time
205205
# (Asia/Karachi)
206206
PKST 21600 D # Pakistan Summer Time
@@ -229,19 +229,19 @@ UZST 21600 D # Uzbekistan Summer Time
229229
UZT 18000 # Uzbekistan Time
230230
# (Asia/Samarkand)
231231
# (Asia/Tashkent)
232-
VLAST 39600 D # Vladivostok Summer Time
232+
VLAST 39600 D # Vladivostok Summer Time (obsolete)
233233
# (Asia/Vladivostok)
234-
VLAT 36000 # Vladivostok Time
234+
VLAT 39600 # Vladivostok Time (caution: this used to mean 36000)
235235
# (Asia/Vladivostok)
236236
WIT 25200 # Waktu Indonesia Timur
237237
# West Indonesia Time
238238
# (Asia/Jakarta)
239239
# (Asia/Pontianak)
240-
YAKST 36000 D # Yakutsk Summer Time
240+
YAKST 36000 D # Yakutsk Summer Time (obsolete)
241241
# (Asia/Yakutsk)
242-
YAKT 32400 # Yakutsk Time
242+
YAKT 36000 # Yakutsk Time (caution: this used to mean 32400)
243243
# (Asia/Yakutsk)
244-
YEKST 21600 D # Yekaterinburg Summer Time
244+
YEKST 21600 D # Yekaterinburg Summer Time (obsolete)
245245
# (Asia/Yekaterinburg)
246-
YEKT 18000 # Yekaterinburg Time
246+
YEKT 21600 # Yekaterinburg Time (caution: this used to mean 18000)
247247
# (Asia/Yekaterinburg)

‎src/timezone/tznames/Atlantic.txt

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Atlantic.txt,v 1.2 2006/07/25 13:49:21 tgl Exp $
7+
# src/timezone/tznames/Atlantic.txt
88
#
99

1010
# CONFLICT! ADT is not unique

‎src/timezone/tznames/Australia

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# timezone_abbreviations to 'Australia'. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Australia,v 1.2 2006/07/25 13:49:21 tgl Exp $
7+
# src/timezone/tznames/Australia
88

99

1010
# include the default set

‎src/timezone/tznames/Australia.txt

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Australia.txt,v 1.3 2009/09/06 15:25:23 tgl Exp $
7+
# src/timezone/tznames/Australia.txt
88
#
99

1010
ACSST 37800 D # Central Australia (not in zic)

‎src/timezone/tznames/Default

Lines changed: 28 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# timezone_abbreviations to 'Default'. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Default,v 1.9.2.1 2010/08/26 19:58:50 tgl Exp $
7+
# src/timezone/tznames/Default
88

99

1010
#################### AFRICA ####################
@@ -239,7 +239,7 @@ DDUT 36000 # Dumont-d'Urville Time (Antarctica)
239239
# (Antarctica/DumontDUrville)
240240
# (Antarctica/Palmer)
241241
# (America/Santiago)
242-
MAWT 21600 # Mawson Time (Antarctica)
242+
MAWT 18000 # Mawson Time (Antarctica) (caution: this used to mean 21600)
243243
# (Antarctica/Mawson)
244244

245245
#################### ASIA ####################
@@ -273,9 +273,9 @@ BORT 28800 # Borneo Time (Indonesia) (not in zic)
273273
BTT 21600 # Bhutan Time
274274
# (Asia/Thimphu)
275275
CCT 28800 # China Coastal Time (not in zic)
276-
GEST 14400 D # Georgia Summer Time (there was a timezone change in 2004)
276+
GEST 14400 D # Georgia Summer Time (obsolete)
277277
# (Asia/Tbilisi)
278-
GET 10800 # Georgia Time (there was a timezone change in 2004)
278+
GET 14400 # Georgia Time (caution: this used to mean 10800)
279279
# (Asia/Tbilisi)
280280
HKT 28800 # Hong Kong Time (not in zic)
281281
ICT 25200 # Indochina Time
@@ -284,9 +284,9 @@ ICT 25200 # Indochina Time
284284
# (Asia/Saigon)
285285
# (Asia/Vientiane)
286286
IDT 10800 D # Israel Daylight Time
287-
IRKST 32400 D # Irkutsk Summer Time
287+
IRKST 32400 D # Irkutsk Summer Time (obsolete)
288288
# (Asia/Irkutsk)
289-
IRKT 28800 # Irkutsk Time
289+
IRKT 32400 # Irkutsk Time (caution: this used to mean 28800)
290290
# (Asia/Irkutsk)
291291
IRT 12600 # Iran Time (not in zic)
292292
# CONFLICT! IST is not unique
@@ -298,42 +298,42 @@ JAYT 32400 # Jayapura Time (Indonesia) (not in zic)
298298
JST 32400 # Japan Standard Time
299299
# (Asia/Tokyo)
300300
KDT 36000 D # Korean Daylight Time (not in zic)
301-
KGST 21600 D # Kyrgyzstan Summer Time
301+
KGST 21600 D # Kyrgyzstan Summer Time (obsolete)
302302
# (Asia/Bishkek)
303-
KGT 18000 # Kyrgyzstan Time
303+
KGT 21600 # Kyrgyzstan Time (caution: this used to mean 18000)
304304
# (Asia/Bishkek)
305-
KRAST 28800 D # Krasnoyarsk Summer Time
305+
KRAST 28800 D # Krasnoyarsk Summer Time (obsolete)
306306
# (Asia/Krasnoyarsk)
307-
KRAT 25200 # Krasnoyarsk Time
307+
KRAT 28800 # Krasnoyarsk Time (caution: this used to mean 25200)
308308
# (Asia/Krasnoyarsk)
309309
KST 32400 # Korean Standard Time
310310
# (Asia/Pyongyang)
311311
LKT 21600 # Lanka Time
312312
# (Asia/Colombo)
313-
MAGST 43200 D # Magadan Summer Time
313+
MAGST 43200 D # Magadan Summer Time (obsolete)
314314
# (Asia/Magadan)
315-
MAGT 39600 # Magadan Time
315+
MAGT 43200 # Magadan Time (caution: this used to mean 39600)
316316
# (Asia/Magadan)
317317
MMT 23400 # Myanmar Time
318318
# (Asia/Rangoon)
319319
MYT 28800 # Malaysia Time
320320
# (Asia/Kuala_Lumpur)
321321
# (Asia/Kuching)
322-
NOVST 25200 D # Novosibirsk Summer Time
322+
NOVST 25200 D # Novosibirsk Summer Time (obsolete)
323323
# (Asia/Novosibirsk)
324-
NOVT 21600 # Novosibirsk Time
324+
NOVT 25200 # Novosibirsk Time (caution: this used to mean 21600)
325325
# (Asia/Novosibirsk)
326326
NPT 20700 # Nepal Time
327327
# (Asia/Katmandu)
328-
OMSST 25200 D # Omsk Summer Time
328+
OMSST 25200 D # Omsk Summer Time (obsolete)
329329
# (Asia/Omsk)
330-
OMST 21600 # Omsk Time
330+
OMST 25200 # Omsk Time (caution: this used to mean 21600)
331331
# (Asia/Omsk)
332332
PETST 46800 D # Petropavlovsk-Kamchatski Summer Time
333333
# (Asia/Kamchatka)
334334
PETT 43200 # Petropavlovsk-Kamchatski Time
335335
# (Asia/Kamchatka)
336-
PHT 28800 # Phillipine Time (not in zic)
336+
PHT 28800 # Philippine Time (not in zic)
337337
PKT 18000 # Pakistan Time
338338
# (Asia/Karachi)
339339
PKST 21600 D # Pakistan Summer Time
@@ -354,17 +354,17 @@ UZST 21600 D # Uzbekistan Summer Time
354354
UZT 18000 # Uzbekistan Time
355355
# (Asia/Samarkand)
356356
# (Asia/Tashkent)
357-
VLAST 39600 D # Vladivostok Summer Time
357+
VLAST 39600 D # Vladivostok Summer Time (obsolete)
358358
# (Asia/Vladivostok)
359-
VLAT 36000 # Vladivostok Time
359+
VLAT 39600 # Vladivostok Time (caution: this used to mean 36000)
360360
# (Asia/Vladivostok)
361-
YAKST 36000 D # Yakutsk Summer Time
361+
YAKST 36000 D # Yakutsk Summer Time (obsolete)
362362
# (Asia/Yakutsk)
363-
YAKT 32400 # Yakutsk Time
363+
YAKT 36000 # Yakutsk Time (caution: this used to mean 32400)
364364
# (Asia/Yakutsk)
365-
YEKST 21600 D # Yekaterinburg Summer Time
365+
YEKST 21600 D # Yekaterinburg Summer Time (obsolete)
366366
# (Asia/Yekaterinburg)
367-
YEKT 18000 # Yekaterinburg Time
367+
YEKT 21600 # Yekaterinburg Time (caution: this used to mean 18000)
368368
# (Asia/Yekaterinburg)
369369

370370
#################### ATLANTIC ####################
@@ -622,10 +622,12 @@ MEST 7200 D # Middle Europe Summer Time (not in zic)
622622
MET 3600 # Middle Europe Time (not in zic)
623623
METDST 7200 D # Middle Europe Summer Time (not in zic)
624624
MEZ 3600 # Mitteleuropaeische Zeit (German) (not in zic)
625-
MSD 14400 D # Moscow Daylight Time
625+
MSD 14400 D # Moscow Daylight Time (obsolete)
626626
# (Europe/Moscow)
627-
MSK 10800 # Moscow Time
627+
MSK 14400 # Moscow Time (caution: this used to mean 10800)
628628
# (Europe/Moscow)
629+
VOLT 14400 # Volgograd Time
630+
# (Europe/Volgograd)
629631
WET 0 # Western Europe Time
630632
# (Africa/Casablanca)
631633
# (Africa/El_Aaiun)
@@ -714,7 +716,7 @@ PWT 32400 # Palau Time
714716
# (Pacific/Palau)
715717
TAHT -36000 # Tahiti Time (zic says "TAHT", other sources "THAT")
716718
# (Pacific/Tahiti)
717-
TKT -36000 # Tokelau Time
719+
TKT 46800 # Tokelau Time (caution: this used to mean -36000)
718720
# (Pacific/Fakaofo)
719721
TOT 46800 # Tonga Time (not in zic)
720722
TRUT 36000 # Truk Time (zic used to say "TRUT", other sources say "TRUK")

‎src/timezone/tznames/Etc.txt

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Etc.txt,v 1.2 2006/07/25 13:49:21 tgl Exp $
7+
# src/timezone/tznames/Etc.txt
88
#
99

1010
GMT 0 # Greenwich Mean Time

‎src/timezone/tznames/Europe.txt

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Europe.txt,v 1.3 2009/09/06 15:25:23 tgl Exp $
7+
# src/timezone/tznames/Europe.txt
88
#
99

1010
BST 3600 D # British Summer Time
@@ -185,14 +185,16 @@ MEST 7200 D # Middle Europe Summer Time (not in zic)
185185
MET 3600 # Middle Europe Time (not in zic)
186186
METDST 7200 D # Middle Europe Summer Time (not in zic)
187187
MEZ 3600 # Mitteleurop�ische Zeit (German) (not in zic)
188-
MSD 14400 D # Moscow Daylight Time
188+
MSD 14400 D # Moscow Daylight Time (obsolete)
189189
# (Europe/Moscow)
190-
MSK 10800 # Moscow Time
190+
MSK 14400 # Moscow Time (caution: this used to mean 10800)
191191
# (Europe/Moscow)
192-
SAMST 18000 D # Samara Summer Time
192+
SAMST 18000 D # Samara Summer Time (obsolete)
193193
# (Europe/Samara)
194194
SAMT 14400 # Samara Time
195195
# (Europe/Samara)
196+
VOLT 14400 # Volgograd Time
197+
# (Europe/Volgograd)
196198
WEST 3600 D # Western Europe Summer Time
197199
# (Africa/Casablanca)
198200
# (Atlantic/Canary)

‎src/timezone/tznames/India

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# timezone_abbreviations to 'India'. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/India,v 1.2 2006/07/25 13:49:21 tgl Exp $
7+
# src/timezone/tznames/India
88

99

1010
# include the default set

‎src/timezone/tznames/Indian.txt

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
# a template for timezones you could need. See the `Date/Time Support'
55
# appendix in the PostgreSQL documentation for more information.
66
#
7-
# $PostgreSQL: pgsql/src/timezone/tznames/Indian.txt,v 1.3 2009/03/05 14:27:50 heikki Exp $
7+
# src/timezone/tznames/Indian.txt
88
#
99

1010
CCT 23400 # Cocos Islands Time (Indian Ocean)

0 commit comments

Comments
 (0)