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

Reply via email to