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