Acácio Nuno wrote:
>
> Hi PL/SQL programers,
>
> I need to kown the number of days between two dates, if you have a
> function that accepts these
> 2 dates as parameters and returns the number of days between them,
> pleaaaaaase send me!
>
> THANKS!!!!! :)
Hi,
Use two dates with minus (-) sign.
SELECT TO_DATE('20-DEC-94') - TO_DATE(21-DEC-94') FROM DUAL;
AMARENDRA
--
******************************************************************************
AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A
Oracle Certified DBA (OCP) NORRIDGE, IL 60656
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.
Ph.No. (708) 583 9870 (H)
(312) 913 6758 (W)
E-mail:nettama_at_charlie.cns.iit.edu,
anettem_at_whittman-hart.com
Homepage: http://www.iit.edu/~nettama
****************************************************************************
Opinions are mine and do not necessarily reflect those of Whittman-hart
Inc.
Received on Tue Dec 02 1997 - 00:00:00 CST
