Yuva,
There isn't enough information here to really understand what is going
on. For example are you doing the update via sql (i.e. update foo set
bar = bar + '7 hours'::interval) or are you doing the change in java
(i.e. update foo set bar = ? where the bind value is calculated in
java). A simple test case showing the problem would help us better
diagnose your issue.
thanks,
--Barry
Yuva Chandolu wrote:
>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>