Re: Anyone have a DAYS_BETWEEN function?

From: Randall Prentice <RJP0_at_paradise.net.nz>
Date: Wed, 03 Mar 1999 18:24:22 +0800
Message-ID: <36DD0DD6.F42B5CA1@paradise.net.nz>

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 may be totally wrong but from my days using SAS for a date (Stored as integer Number of days since...) you just subtract the two numbers to get the difference.

If it is a datetime value convert to a date first.

Regards Received on Wed Mar 03 1999 - 04:24:22 CST