Re: Time Zone Error - Mailing list pgsql-general

From Richard Huxton
Subject Re: Time Zone Error
Date
Msg-id 464C0CCC.1020805@archonet.com
Whole thread Raw
In response to Time Zone Error  (Jamie Deppeler <jamie@doitonce.net.au>)
Responses Re: Time Zone Error
List pgsql-general
Jamie Deppeler wrote:
> 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

1. These are the same absolute times.
2. Do you have some sort of daylight-saving flag set somewhere?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Windows Vista Support
Next
From: Richard Huxton
Date:
Subject: Re: Time Zone Error