Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres timestamps are out by one hour - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres timestamps are out by one hour
Date
Msg-id 21149.1161877975@sss.pgh.pa.us
Whole thread Raw
In response to Postgres timestamps are out by one hour  ("Simon Kinsella" <simon@bluefiresystems.co.uk>)
Responses Re: Postgres timestamps are out by one hour  ("Simon Kinsella" <simon@bluefiresystems.co.uk>)
List pgsql-admin
Tree view 
"Simon Kinsella" <simon@bluefiresystems.co.uk> writes:
> The shell / system timestamp is correct local time (London, daylight
> saving), but the postgres time is one hour behind.

What does SHOW TIMEZONE say?

            regards, tom lane

pgsql-admin by date:

Previous
From: Jari Vauhkonen
Date:
Subject: Re: TCP/IP connection problem
Next
From: Ben Suffolk
Date:
Subject: Re: TCP/IP connection problem