Date time problem with timstamp with no timezone data type - Mailing list pgsql-jdbc

From Yuva Chandolu
Subject Date time problem with timstamp with no timezone data type
Date
Msg-id A0F24737FCB34F489EC955D143BDD851BF8504@exchange-sf1.corp.ebates.com
Whole thread Raw
List pgsql-jdbc
Hi,

We have weiered problem with one timestamp(without timezone) data type
column(updated_date) in one table.  We insert a row into this table with
current time once and susequently update it many times with current time.
What happens is with each update the updated_date is increased by 7 hours.
We are in PDT timezone and for initial insert +7 hours is fine but
subsequent updates increasing it by +7 hours is wiered. What should we do
here?

We are using stable pgjdbc2.jar and we are using postgres7.2.1.

Thanks
Yuva

pgsql-jdbc by date:

Previous
From: "Chris White"
Date:
Subject: Re: Getting oid of 0 when doing LargeObjectManager.create()
Next
From: "Ulrich Finkler"
Date:
Subject: Problem with jdbc and german special characters under linux...