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
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 |