From: | Peter Katzmann <p(dot)katzmann(at)thiesen(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Timestamp problems |
Date: | 2003-02-06 13:44:12 |
Message-ID: | 3E4266AC.4060907@thiesen.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Rosenberg | 2003-02-06 14:14:00 | Re: moveToInsertRow SQL Exception "No Primary Keys" |
Previous Message | Peter Katzmann | 2003-02-06 12:24:43 | Timestamp problems |