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