Time Zone Error - Mailing list pgsql-general

From Jamie Deppeler
Subject Time Zone Error
Date
Msg-id 464C0064.7070804@doitonce.net.au
Whole thread Raw
Responses Re: Time Zone Error
Re: Time Zone Error
List pgsql-general
Hi,

We currently running Windows 2003 issues with time zone set to
(GMT-05:00) Eastern Time (US & Canada). Problem that we currently have
with Postgresql 8.1.5 is that time zone is being reported with a
incorrect off set –4 not –5 and this is causing incorrect time to be set.

Below is example out put

Windows Time
2007-05-17 00:55:32.327-05

Postgresql Time
2007-05-17 01:55:32.327-04



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Vacuum non-clustered tables only
Next
From: Dave Page
Date:
Subject: Re: Windows Vista Support