PDT but not WEST

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема PDT but not WEST
Дата
Msg-id 81EF1924-402E-410D-9885-53E52D1BCED8@thebuild.com
обсуждение исходный текст
Ответы Re: PDT but not WEST
Re: PDT but not WEST
Список 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@thebuild.com


В списке pgsql-general по дате отправления: