Re: "HDT" time zone not recognized by PostreSQL 9.5

From: Pavol Szegheo <PSzegheo(at)itnnetworks(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: "HDT" time zone not recognized by PostreSQL 9.5
Date: 2016-09-23 19:47:22
Message-ID: MWHPR07MB2799DEAABAF032F71E225A7AD2C80@MWHPR07MB2799.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Neither are the more modern HADT and HAST time zones recognized by PostreSQL 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(at)postgresql(dot)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
*/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pszegheo 2016-09-23 19:52:17 BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5
Previous Message Pavol Szegheo 2016-09-23 19:35:32 "HDT" time zone not recognized by PostreSQL 9.5