Date Fuction

[clarence]

Hi All

is the a date fuction I can use to get the a number of days between two date variables.
e.g number of days between 02-APR-02 and 03-APR-02.

Thanx

[julian]

How about the minus (-) function :-)

SQL> select to_date('03.04.2002','dd.mm.yyyy')-to_date('02.04.2002','dd.mm.yyyy') DAYS from dual;

      DAYS
----------
         1

SQL>

[marist89]

Date subtraction...

  1  select
  2  to_date('02/02/2002','mm/dd/yyyy') - to_date('03/04/2002','mm/dd/yyyy') date_diff
  3* from dual
SQL> /

 DATE_DIFF
----------
       -30

[Tarry]

SQL> select trunc(sysdate-to_date('20/03/02','dd/mm/yy')) "Diff"
2 from dual;

Diff
----------
14