Re: ??? Number of days betwwen two dates?

Suggest you convert to Julian to_char(date,'J') and then subtract one from the other.
Regards
Duncan Berriman

Huang, Joseph <huang_at_baptized.com.---> wrote in article <5rnq02$d28_at_bolivia.earthlink.net>...
 I need a function, which I can use in other stored procedures, to return number of days of two given dates. The only similar function I can found in Oracle manual is MONTHS_BETWEEN(). However, the problem is MONTHs_BETWEEN() return number based on 31-day month which is incorrect normally. For example, instead of 29 days, the function returns 1.0322581 (32 days) from 02/01/97 to 03/02/97.

Before writing our own function to get correct number of days, I'd like to know whether this kind of function exists somewhere so I don't need to redo it. Any suggestions?

Thanks in advance.

Joseph Huang

-- 
My email address is intentionally invalid to foil spammers.  Delete the
".---" to get my real address.


----------