Re: Oracle Dates
Date: Sun, 10 Jan 2010 23:09:15 -0700
I believe the value you are looking for is:
When oracle subtracts dates you get the number in days.
"The Magnet" <art_at_unsu.com> wrote in message
> Is there a way for me to figure out how many days in 3 months? For
> example, say I have this:
> x := ADD_MONTHS(v_date,3);
> Depending on the value of v_date the months may not be 90, since some
> have 30 and others 31 days.
> So, how can I get an integer from those 3 months which are being
> added? If v_date is March, I want 91. If v_date is October, I want
Received on Mon Jan 11 2010 - 00:09:15 CST