When passing a date parameter to the database, the time part is always set to 00:01:01
Date: Wed, 18 Aug 1999 11:00:33 GMT
Message-ID: <7pe3od$mit$1_at_nnrp1.deja.com>
We're using Forms 4.5 here with an Oracle 8.0.5 Database, everything in Unix on the same workstation.
In the database, we have as function in a package
PACKAGE BODY PLAUSI IS
FUNCTION test( d IN DATE ) return varchar2 IS
BEGIN
return(to_char(d,'DD-MON-YYYY HH24:MI:SS'));
END;
END;
which I am calling from Forms:
messagebox(plausi.test(to_date('18-AUG-1999 18:04:00', 'DD-MON-YYYY HH24:MI:SS')));
The procedure messagebox simply shows a message. The problem we are having here is that the time part of the date is not properly passed to the database. The message that appears is:
18-AUG-1999 00:01:01
The problem appears only with Forms in Unix, not in WinNT.
We are using Net8, TCP/IP Protocol Adapter and Oracle Enterprise Edition 8.0.5.0.0 and Oracle Forms Client Server Release 4.5.10.6.0.
Has anyone ever had this problem before?
Uwe Embshoff
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Aug 18 1999 - 13:00:33 CEST