Re: BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pszegheo(at)itnnetworks(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5
Date: 2016-09-23 20:56:59
Message-ID: 28556.1474664219@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pszegheo(at)itnnetworks(dot)com writes:
> "HDT" time zone is not recognized by PostreSQL 9.5
> Neither are the more modern HADT and HAST time zones recognized by PostreSQL
> 9.5

The IANA timezone database does not think that either HAST or HDST have
ever been in common use, and HDT hasn't been in use since 1945:

# Zone NAME GMTOFF RULES FORMAT [UNTIL]
Zone Pacific/Honolulu -10:31:26 - LMT 1896 Jan 13 12:00
-10:30 - HST 1933 Apr 30 2:00
-10:30 1:00 HDT 1933 May 21 12:00
-10:30 - HST 1942 Feb 9 2:00
-10:30 1:00 HDT 1945 Sep 30 2:00
-10:30 - HST 1947 Jun 8 2:00
-10:00 - HST

We generally avoid including nonstandard abbreviations in PG's default
timezone abbreviations list, since they seem more likely to allow garbage
data to be entered than to be useful. Of course, you can set up your own
abbreviation list if you wish to use specific additional abbreviations.
See
https://www.postgresql.org/docs/9.5/static/datetime-config-files.html

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2016-09-23 21:05:31 Re: BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5
Previous Message Thomas Munro 2016-09-23 20:48:44 Re: BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5