Oracle-L: RE: Date difference function

From: ISI/BDD/HAOUHACH <lhaouhach_at_avl.sonatrach.dz>
Date: Mon, 10 Mar 2003 05:18:52 -0800
Message-ID: <F001.005645A5.20030310051852@fatcity.com>

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')

-----Message d'origine-----
De : Santosh Varma [mailto:vsantosh_at_psi.soft.net] 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: ISI/BDD/HAOUHACH
INET: lhaouhach_at_avl.sonatrach.dz

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: ListGuru_at_fatcity.com (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). Received on Mon Mar 10 2003 - 07:18:52 CST