Timestamp with Timezone

From: "Chris M(dot) Gamble" <chris(dot)gamble(at)cpbinc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Timestamp with Timezone
Date: 2004-08-25 17:35:16
Message-ID: 9E0E7DA2130F1D42861EC43B568E99FC140F0D@mail1.cpbinc.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I recently upgraded an application from postgresql 7.4.2 to 7.4.5, and now I am having timezone nightmares.

I checked on the old server, and found that in the postgresql.conf, the timezone was set for unknown. The timezone portion of the records was being set to GMT+06 ( for reference, I am in GMT-06 ). Now, on the old server, when i pulled data, the dates came back correctly.

However, on the new server, I am getting dates that adjust properly for the timezone in the record, which means that my records show as having been entered a day before, which is killing my users. Can someone help me understand the timezone nightmare, and how i can fix my records so that they appear on the correct day?

I am using the exact same jdbc library to connect to both servers, and my setup is:

OLD Setup
Redhat 9
Postgres 7.4.2 (compiled from source)

NEW Setup
Redhat 3 Enterprise
Postgres 7.4.5 (compiled from source)

Thanks,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-08-25 18:05:16 Re: The Slony General List
Previous Message Philip A. Chapman 2004-08-25 17:08:25 pgTcl and Refcursors