date difference

"jain cj" <[email protected]> Thu, 28 Aug 2003 13:49:52 +0000

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<[email protected]>

Hi,

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.