Oracle Dates

From: The Magnet <>
Date: Tue, 5 Jan 2010 16:32:37 -0800 (PST)
Message-ID: <>

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 92.

Thanks! Received on Tue Jan 05 2010 - 18:32:37 CST

Original text of this message