Thread: postgres time zone settings

<div dir="ltr">Hai all,<br /><br />when i was going through the Postgresql documents, i came across a section which
tellsabout the TIME ZONE settings<br /><br /><br />what i understood from the document is, based on the value given in
thisconf file postgres will add or subtract the displacement hours to the system time assuming that the system time is
theGMT. <br />so there should be a configuration settings which will tell the postgres that the displacement is
zero.<br/>How I can set the displacement is zero?<br /><br />Thanks in advance<br />Anoop<br /><br /></div> 

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