Hi,
Found another post describing my problem unfortunately that didn't have a reply
either.
-Ajit
---------------------- from the list archive -----------------------
[EMAIL PROTECTED] [EMAIL PROTECTED]
Thu, 30 Jan 2003 12:43:39 +0100
Previous message: Q: Extended stored proc
Next message: Current Date Time...
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
-----Original Message-----
From: ajit_cus
Sent: Tuesday, June 03, 2003 2:38 PM
To: '[EMAIL PROTECTED]'
Subject: oracle date problem
Hi,
I'm running 7.3.30 and executing queries in ORACLE mode
Inserting these into a date column always causes the time to be "00:50"
TO_DATE('2003/06/03/19 00:50', 'YYYY/MM/DD/SS HH24:MI')
TO_DATE('2003/06/03/50 12:50', 'YYYY/MM/DD/SS HH24:MI')->inserts 00:50 as time
Is this a known bug?
If so in what version was it fixed?
Regards,
Ajit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
