Here I am facing one problem. I want to find the date difference like this
SELECT
uf.*
FROM
SI_UnavailableFund_v uf, SI_BusinessDate bd
WHERE
(bd.BusinessDate - (NVL( uf.ExpiryDate, TO_DATE( '01-01-2300', 'MM-DD-YYYY' ))) < 0)
but it is not allowing NVL here. (Oracle mode)
Internal mode is supporting 'DATEDIFF' but it will give +ve value always no <0 .
so how can find the date difference (+ve and -ve not absolute value).
please help me
by jain
_________________________________________________________________
ICICI's NRI services. They make life easy. http://server1.msn.co.in/msnspecials/nriservices/index.asp Find out more.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
