Re: postgres time zone settings - Mailing list pgsql-sql

From Jaime Casanova
Subject Re: postgres time zone settings
Date
Msg-id 3073cc9b0807240947i633dee42ncb3f3e6465f51c3d@mail.gmail.com
Whole thread Raw
In response to postgres time zone settings  ("Anoop G" <anoopmadavoor@gmail.com>)
List 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 by date:

Previous
From: Shane Ambler
Date:
Subject: Re: truncate vs. delete
Next
From: Giorgio Valoti
Date:
Subject: Re: Select default values