Devart Forums

I'm using TOraStoredProc. I pass as input parameter two tDateTime parameters different by their time.
My store proc behaves like the two parameter values have the same time.
I suppose ODAC truncate time part while assigning values to TDateTime this way:
OraStoredProc.Params.CreateParam(ftDateTime, 'startdatetime', ptInput).AsDateTime := StrToDateTime(Search1.beginningdate)

Does anybody know if there's a bug 'working' like that in ODAC.

Search1.beginningdate is a string like '03/08/2006 12:23:24', of course.

Can anybody help me?
Thanks

Sorry, I've forget ODAC version: 5.70.1.33 for Delphi 7.

Bye
Matteo

We cannot reproduce the problem. ODAC doesn't truncate time part for ftDateTime parameters.

You could try passing the date and time as a string and converting it in the SP with a to_date().