Date losing time portion w/ADO & Oracle Stored Procedure
When calling an Oracle stored procedure (SP) any dates, passed in or out,
lose their time. For example if the date "2000-oct-21 12:13:24" is returned
from the SP, as a date, VB receives "2000 Oct 21 00:00:00".
create or replace
procedure test (outdate out date) is
outdate := to_date ( '2000-oct-21 12:13:24', 'YYYY-Mon-DD HH24.MI.SS');
.ActiveConnection = m_adoConnection
.CommandText = "test"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("outdate", adDate, adParamOutput)
MsgBox "Return value from stored procedure is " & Format(m_adoCommandOne("outdate"),
"yyyy/mmm/dd hh:nn:ss") & "."
It seems to me that VB is the culprit dropping the time information. Is their
a method or alternative datatype, besides using strings, that works properly
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL