Re: postgres time zone settings

On Thu, Jul 24, 2008 at 7:56 AM, Anoop G <anoopmadavoor(at)gmail(dot)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