ADMIN] Postgres timestamps are out by one hour
"Simon Kinsella" <[EMAIL PROTECTED]> writes:
> template1=# show timezone;
> TimeZone
> --
> GMT0
That's a non-daylight-savings zone ... and one would guess that the
postmaster was started with TZ=GMT or some
"Simon Kinsella" <[EMAIL PROTECTED]> writes:
> template1=# show timezone;
> TimeZone
> --
> GMT0
That's a non-daylight-savings zone ... and one would guess that the
postmaster was started with TZ=GMT or some such, else it would not have
picked that as the Postgres zone.
template1=# show timezone;
TimeZone
--
GMT0
Thanks.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, October 26, 2006 4:53 PM
To: Simon Kinsella
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres timestamps are
"Simon Kinsella" <[EMAIL PROTECTED]> 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
---(end of broadcast)---
Hello,
I'm experiencing a strange problem on two of my installs (PostgreSQL 8.1.4
on FreeBSD6.1-Release):
>From the shell:
[EMAIL PROTECTED]> date
Thu Oct 26 16:03:09 BST 2006
>From psql/any sql client:
template1=# select now();
now
--
2006-10-26 15:03
