RE: Date difference function

From: Darrell Landrum <dlandrum_at_zalecorp.com>
Date: Mon, 10 Mar 2003 07:29:19 -0800
Message-ID: <F001.005647E8.20030310072919@fatcity.com>

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.

<<< lhaouhach_at_avl.sonatrach.dz 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: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: Darrell Landrum
  INET: dlandrum_at_zalecorp.com

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 - 09:29:19 CST