Re: Timestamp problems

Peter,

When you say you tried with the current version what do you mean?
Specifically have you tried the latest 7.3 build from
jdbc.postgresql.org?  There were some recent bug fixes in this area that
I think may fix your problem.

If the current code still has this problem, can you submit a test case
that we can compile and run that demonstrates the problem?

thanks,
--Barry


Peter Katzmann wrote:
> High,
> i' currently working with hibernate. They represent Calendar types as
> timestamps. During prepareStatement and setTimestamp the data generated for
> the query has a modified date. The date is something original:
>
>
> insert into hours  ( entrydate, activitydate, remark, time, userid,
> checked,
> phaseid, activityid, zkub, id ) values  '2003-02-06 11:11:29.338000000+00',
> '2003-02-06 11:11:29.338000000+00', 'öfölsdajklö', 120, 'pk1057', 'f',
> null,
> null, null, 12747 )
>
>
> And this will be aftter the data was read back, the checked flag changed
> and
> wrote back
>
> update hours set entrydate = '2003-02-05 23:00:00.000000000+00',
> activitydate
> = '2003-02-05 23:00:00.000000000+00', remark = 'öfölsdajklö', time = 120,
> userid = 'pk1057', checked = 't', phaseid = 5, activityid = 3, zkub = ' '
> where id = 12747
>
> First occured the problem with postgres 7.2 so i updated to a current
> version,
> but no go either.
>
>
> peter
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>