Hi,
ich have problems with inserting hour values > 12!
I read in the release info of the sapdb version 7.3.00.29,
that this bug should be solved. (PTS: 1117002 )
But i use the sapdb version 7.3.0 Build 029-000-087-800
and the bug appears on my system!
I did the following:
CREATE TABLE "DATETEST"
(
"DATE_value" Timestamp
)
insert into datetest (date_value) values
(to_date('30.01.2003:12:00:00','DD.MM.YYYY:HH24:MI:SS'))
Then the select : select to_char(date_value,'DD.MM.YYYY:HH24:MI:SS') from datetest
gets the date value: 30.01.2003:00:00:00!!!
Is this another bug?
Thanks
Christoph Brunner
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general