Timestamp problems
От | Peter Katzmann |
---|---|
Тема | Timestamp problems |
Дата | |
Msg-id | 3E42540B.60002@thiesen.com обсуждение исходный текст |
Список | 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 по дате отправления: