Date time problem with timstamp with no timezone data type

From: Yuva Chandolu <ychandolu(at)ebates(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Date time problem with timstamp with no timezone data type
Date: 2002-07-11 08:12:07
Message-ID: A0F24737FCB34F489EC955D143BDD851BF8504@exchange-sf1.corp.ebates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ulrich Finkler 2002-07-11 14:00:19 Problem with jdbc and german special characters under linux...
Previous Message Chris White 2002-07-11 05:42:51 Re: Getting oid of 0 when doing LargeObjectManager.create()