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

From: pszegheo(at)itnnetworks(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5
Date: 2016-09-23 19:52:17
Message-ID: 20160923195217.1517.16332@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14337
Logged by: Pavol Szegheo
Email address: pszegheo(at)itnnetworks(dot)com
PostgreSQL version: 9.5.4
Operating system: Windows 10
Description:

"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

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

e.g.:
SELECT TIMESTAMP '2013-08-13 00:00:00' AT TIME ZONE 'HDT';
/*
Example output:
ERROR: time zone "HDT" not recognized
********** Error **********

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2016-09-23 20:48:44 Re: BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5
Previous Message Pavol Szegheo 2016-09-23 19:47:22 Re: "HDT" time zone not recognized by PostreSQL 9.5