Re: Time Zone Error

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Time Zone Error
Date: 2007-05-17 08:05:32
Message-ID: 464C0CCC.1020805@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jamie Deppeler 2007-05-17 08:08:48 Re: Time Zone Error
Previous Message Richard Huxton 2007-05-17 08:04:35 Re: Windows Vista Support