8.1beta timezone question
| От | Bricklen Anderson |
|---|---|
| Тема | 8.1beta timezone question |
| Дата | |
| Msg-id | 43204CD4.1050808@PresiNET.com обсуждение исходный текст |
| Список | pgsql-general |
I may have missed it in the docs, but were certain timestamp abbreviations
phased out between 8.0.3 and 8.1 beta1?
eg.
(8.0.3)
#SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'PST';
timezone
-------------------------
16/02/2001 20:38:40 PST
(8.1beta1)
#SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'PST';
ERROR: time zone "PST" not recognised
The tzname still works fine, though:
SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific';
timezone
-------------------------
16/02/2001 20:38:40 PST
Or maybe there is a setting that I neglected to adjust to make this work on
8.1beta1? The same error occurs with several other timezone abbreviations that I
tried.
Cheers,
Bricklen
--
_______________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
В списке pgsql-general по дате отправления: