Results 1 to 3 of 3

Thread: date difference

  1. #1
    Join Date
    Sep 2004
    Posts
    8

    Unanswered: date difference

    hi to all,


    how can i calculate no of days between two dates?

    please help with an eg.

    thanks,
    hetav

  2. #2
    Join Date
    Nov 2002
    Posts
    833

  3. #3
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Hello,

    Try this :

    ROUND(date2 - date1)

    example :

    Code:
    SQL> select round(to_date('15/03/2004') - to_date('10/03/2004')) as Number_Of_Days from dual;
    
    NUMBER_OF_DAYS
    --------------
                 5
    
    SQL>
    Regards,

    RBARAER

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •