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 по дате отправления:

Предыдущее
От: Łukasz Piątek
Дата:
Сообщение: Hierarchic database
Следующее
От: shk@linuxbr.com.br
Дата:
Сообщение: possible character accent bug on pgjdbc73