| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | pgsql-general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | PDT but not WEST |
| Date: | 2011-09-29 17:17:50 |
| Message-ID: | 81EF1924-402E-410D-9885-53E52D1BCED8@thebuild.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am baffled. Both PDT and WEST appear as valid timezone abbreviations, and each have unique values, but:
test=# select timestamp with time zone '2011-09-29 18:00 PDT';
timestamptz
------------------------
2011-09-29 18:00:00-07
(1 row)
test=# select timestamp with time zone '2011-09-29 18:00 WEST';
ERROR: invalid input syntax for type timestamp with time zone: "2011-09-29 18:00 WEST"
LINE 1: select timestamp with time zone '2011-09-29 18:00 WEST';
What am I missing? Is the parser insisting on three-letter time zone abbreviations? Should it be?
--
-- Christophe Pettus
xof(at)thebuild(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2011-09-29 17:37:22 | Re: PDT but not WEST |
| Previous Message | dennis jenkins | 2011-09-29 17:08:52 | Solaris 10u9, PG 8.4.6, 'c' lang function, fails on 1 of 5 servers |