Re: Oracle Dates
From: joel garry <joel-garry_at_home.com>
Date: Tue, 5 Jan 2010 16:59:48 -0800 (PST)
Message-ID: <117d193a-2dae-4c35-b19e-3167f2f5afc3_at_l30g2000yqb.googlegroups.com>
On Jan 5, 4:32 pm, The Magnet <a..._at_unsu.com> wrote:
> 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!
Date: Tue, 5 Jan 2010 16:59:48 -0800 (PST)
Message-ID: <117d193a-2dae-4c35-b19e-3167f2f5afc3_at_l30g2000yqb.googlegroups.com>
On Jan 5, 4:32 pm, The Magnet <a..._at_unsu.com> wrote:
> 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!
It may be that I'm just too tired, but your question seems ambiguous. Anyways, see http://jonathanlewis.wordpress.com/2009/08/18/why-test/
jg
-- _at_home.com is bogus. http://twittersmarketinghell.com/Received on Tue Jan 05 2010 - 18:59:48 CST