For more robust date operations, you might research the date related functions such as
add_months, months_between, etc.
Look at the documentation at http://technet.oracle.com
or search the web for code samples. These are fun to play with.
<<< [EMAIL PROTECTED] 3/10 7:48a >>>
Just do
Select to_date(date2)-to_date(date1) from dual;
exemple:
SQL> select to_date('16/02/2003')-to_date('12/02/2003') from dual;
TO_DATE('16/02/2003')-TO_DATE('12/02/2003')
-------------------------------------------
4
-----Message d'origine-----
De : Santosh Varma [mailto:[EMAIL PROTECTED]
Envoy� : lundi 10 mars 2003 10:39
� : Multiple recipients of list ORACLE-L
Objet : Date difference function
Hello list,
I want to find the difference between 2 dates..
Any Oracle function for that ???
Thanks and Regards,
Santosh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Darrell Landrum
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
