Time Zone Setting
| От | James G Wilkinson |
|---|---|
| Тема | Time Zone Setting |
| Дата | |
| Msg-id | 44CA7ACB.5070506@alpinegeophysics.com обсуждение исходный текст |
| Ответы |
Re: Time Zone Setting
|
| Список | pgsql-novice |
I just ran into a small mystery. I am trying to set the time zone
during my session and here is what happens:
megan=# set timezone to 'EST'
megan=# do some work here
megan=# set timezone to 'PST'
ERROR: unrecognized time zone name: "PST"
megan=# set timezone to 'PDT'
ERROR: unrecognized time zone name: "PDT"
megan=# set timezone to 'MST'
megan=# set timezone to 'GMT'
megan=# select version();
version
--------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.0.0 20050519 (Red Hat 4.0.0-8)
My default timezone is PDT for this time of year.
I am a bit mystified. Any suggestions?
Regards,
Jim
В списке pgsql-novice по дате отправления: