Timestamp problems - Mailing list pgsql-jdbc

From Peter Katzmann
Subject Timestamp problems
Date
Msg-id 3E42540B.60002@thiesen.com
Whole thread Raw
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Łukasz Piątek
Date:
Subject: Hierarchic database
Next
From: shk@linuxbr.com.br
Date:
Subject: possible character accent bug on pgjdbc73