Re: "HDT" time zone not recognized by PostreSQL 9.5 - Mailing list pgsql-bugs

Neither are the more modern HADT and HAST time zones recognized by PostreSQ=
L 9.5

So, the only Hawaiian timezone recognized by PostreSQL 9.5 is HST, thus the=
 following would run fine:
SELECT TIMESTAMP '2013-08-13 00:00:00' AT TIME ZONE 'HST';

While all these would fail:

SELECT TIMESTAMP '2013-08-13 00:00:00' AT TIME ZONE 'HDT';

SELECT TIMESTAMP '2013-08-13 00:00:00' AT TIME ZONE 'HADT';

SELECT TIMESTAMP '2013-08-13 00:00:00' AT TIME ZONE 'HAST';


From: Pavol Szegheo
Sent: Friday, September 23, 2016 3:36 PM
To: pgsql-bugs@postgresql.org
Subject: "HDT" time zone not recognized by PostreSQL 9.5

SELECT TIMESTAMP '2013-08-13 00:00:00' AT TIME ZONE 'HDT' AT TIME ZONE 'UTC=
';
/* ERROR:  time zone "HDT" not recognized
********** Error **********

ERROR: time zone "HDT" not recognized
SQL state: 22023
*/