Re: Time Zone Error

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