Time Zone Error

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Time Zone Error
Date: 2007-05-17 07:12:36
Message-ID: 464C0064.7070804@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-05-17 07:57:50 Re: Windows Vista Support
Previous Message Richard Huxton 2007-05-17 06:10:56 Re: Vacuum non-clustered tables only