Re: Number of days -function

sweidanz_at_yahoo.com wrote in message news:<UE4x7.7$yb1.698_at_nsw.nnrp.telstra.net>...
> Folks,
> Is there a way (function or an equation) to retunr number of days between
> two dates?
>
> thanks,
> ZS

Try the as in the following example:
select to_date('22-oct-2001', 'dd-mon-yyyy') - to_date('12-oct-2001', 'dd-mon-yyyy')   from dual;

Regards,
Valentin Minzatu Received on Thu Oct 11 2001 - 06:58:41 CDT