Timestamp problems

From: Peter Katzmann <p(dot)katzmann(at)thiesen(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Timestamp problems
Date: 2003-02-06 12:24:43
Message-ID: 3E42540B.60002@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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Katzmann 2003-02-06 13:44:12 Timestamp problems
Previous Message Curt Sampson 2003-02-06 06:33:19 Re: Connection pooling problems