Re: Anyone have a DAYS_BETWEEN function?

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 3 Mar 1999 05:46:59 GMT
Message-ID: <7biicj$que$1_at_nntp.csufresno.edu>


[Quoted] In article <7bi9k4$2lr$1_at_nnrp1.dejanews.com>,  <cjdavies1999_at_my-dejanews.com> wrote:
>I am looking for a DAYS_BETWEEN function, similar to the MONTHS_BETWEEN
>function provided by Oracle. I would also like to be able to have a more
>general form of the ADD_MONTHS function, something like ADD_TO_DATE(
>date_to_increment, increment ammount, increment_unit).
>
>I welcome any pointers to Web sites where I can find date functions for Oracle
>would be greatly appreciated.

Look up Date Arithmetic in your Oracle SQL Reference manual. Just subtracting two dates gives you the number of days between the two. Received on Wed Mar 03 1999 - 06:46:59 CET

Original text of this message