Re: Is there a function in SQL to calculate days between two dates?

An easy method to determine the number of days between two dates is using the MONTHS_BETWEEN function:

     select months_between(date_1, date_2) * 31 from dual;

If DATE_1 is later than DATE_2 the result is positive, else its negative.

Regards,

Ron Evans
ADVANCED SYSTEMS GROUP
ASGCORP_at_AOL.COM
Ron Evans
ASGCORP_at_AOL.COM Received on Fri Mar 29 1996 - 00:00:00 CET