Re: Postgres timestamps are out by one hour

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Postgres timestamps are out by one hour
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 26 Oct 2006 11:52:55 -0400
Cc: pgsql-admin@xxxxxxxxxxxxxx
Comments: In-reply-to "Simon Kinsella" <simon@xxxxxxxxxxxxxxxxxxxxx> message dated "Thu, 26 Oct 2006 16:17:41 +0100"
In-reply-to: <20061026151745.F0C8C198AC6@xxxxxxxxxxxxxxxxxxxxxxx>
References: <20061026151745.F0C8C198AC6@xxxxxxxxxxxxxxxxxxxxxxx>

"Simon Kinsella" <simon@xxxxxxxxxxxxxxxxxxxxx> 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

Follow-Ups:
- Re: Postgres timestamps are out by one hour
  - From: Simon Kinsella

References:
- Postgres timestamps are out by one hour
  - From: Simon Kinsella

Prev by Date: Re: TCP/IP connection problem
Next by Date: Re: TCP/IP connection problem
Previous by thread: Postgres timestamps are out by one hour
Next by thread: Re: Postgres timestamps are out by one hour
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux