Time Zone Setting

Поиск
Список
Период
Сортировка
От James G Wilkinson
Тема Time Zone Setting
Дата
Msg-id 44CA7ACB.5070506@alpinegeophysics.com
обсуждение исходный текст
Ответы Re: Time Zone Setting  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: "Andrew Hammond"
Дата:
Сообщение: Re: Tables Locks Quetion or Strictlly subsequent numbers
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Time Zone Setting