>I'm having trouble retrieving data from an Oracle Rdb database where a date calculation is involved (eg dDischargeDate - dDob <= 18 years).
>
>I have very little documentation about Rdb. Please note that Rdb is a step-child of Oracle so make no Oracle assumptions!
>
>Is it possible to subtract 2 dates in ANSI SQL92 and get a number of days, months, or years? What is the syntax?
When I have a date parameter for an ORacle retrieval, I have to convert the date to with dtoc() function first:
local cDate
cDate = dtoc(somedate)
My remote view SQL looks like:
...where Ora_DateField = ?cDate and ...
My SQL Passthru construction would be:
"... where Ora_DateField = '" + cDate + "' and ..."
Mark McCasland
Midlothian, TX USA