Thomas Munro <thomas.munro@enterprisedb.com> writes:
>> On Sat, Sep 24, 2016 at 7:52 AM, <pszegheo@itnnetworks.com> wrote:
>>> "HDT" time zone is not recognized by PostreSQL 9.5
> Hmm. src/timezone/data/northamerica does reference HDT though:
Actually, some further digging finds this:
Zone America/Adak 12:13:21 - LMT 1867 Oct 18
-11:46:38 - LMT 1900 Aug 20 12:00
-11:00 - NST 1942
-11:00 US N%sT 1946
-11:00 - NST 1967 Apr
-11:00 - BST 1969
-11:00 US B%sT 1983 Oct 30 2:00
-10:00 US AH%sT 1983 Nov 30
-10:00 US H%sT
So this zone really is using HDT to refer to UTC-9. But it's someplace
in the Aleutians, not Hawaii, and Wikipedia says the total population of
Adak is 326. So I remain dubious that we want to add HDT to the standard
abbreviation list --- there are mighty few people for whom it wouldn't be
a typo.
I see we do list it in the tznames/America.txt data file:
HADT -32400 D # Hawaii-Aleutian Daylight Time (obsolete abbreviation)
# (America/Adak)
HAST -36000 # Hawaii-Aleutian Standard Time (obsolete abbreviation)
# (America/Adak)
HDT -32400 D # Hawaiian-Aleutian Daylight Time
# (America/Adak)
and that seems like the appropriate treatment.
regards, tom lane