Re: postgres time zone settings

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: postgres time zone settings
Дата
Msg-id 3073cc9b0807240947i633dee42ncb3f3e6465f51c3d@mail.gmail.com
обсуждение исходный текст
Ответ на postgres time zone settings  ("Anoop G" <anoopmadavoor@gmail.com>)
Список pgsql-sql
On Thu, Jul 24, 2008 at 7:56 AM, Anoop G <anoopmadavoor@gmail.com> wrote:
> Hai all,
>
> when i was going through the Postgresql documents, i came across a section
> which tells about the TIME ZONE settings
>
>
> what i understood from the document is, based on the value given in this
> conf file postgres will add or subtract the displacement hours to the system
> time assuming that the system time is the GMT.
> so there should be a configuration settings which will tell the postgres
> that the displacement is zero.
> How I can set the displacement is zero?
>

set timezone = 'GMT' (or set the guc in postgresql.conf)

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157


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

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: truncate vs. delete
Следующее
От: Giorgio Valoti
Дата:
Сообщение: Re: Select default values