From: | Barry Lind <barry(at)xythos(dot)com> |
---|---|
To: | Yuva Chandolu <ychandolu(at)ebates(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Date time problem with timstamp with no timezone data |
Date: | 2002-07-11 16:01:35 |
Message-ID: | 3D2DABDF.7090508@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Kennedy | 2002-07-11 16:51:16 | Re: ConnectionPool |
Previous Message | Barry Lind | 2002-07-11 15:55:07 | Re: Getting oid of 0 when doing LargeObjectManager.create() |