Re: Oracle Dates

From: The Magnet <>
Date: Tue, 5 Jan 2010 18:09:43 -0800 (PST)
Message-ID: <>

On Jan 5, 6:48 pm, (Malcolm Dew-Jones) wrote:
> The Magnet ( wrote:
> : Is there a way for me to figure out how many days in 3 months?  For
> I can't test this, but my first thought is to try something like this
> example for counting the days in Jan Feb and March of this year.
>         number count_days_in_3_months :=
>         to_date('1-APR-2010','DD-MON-YYYY')
>         - to_date('1-JAN-2010','DD-MON-YYYY')

Yes, but I do not actually know the months. All I know is that the offset starts with "v_date", and I want to count the days, 3 months forward. Hoping not to have to code a bunch of stuff, must be some function or something. Received on Tue Jan 05 2010 - 20:09:43 CST

Original text of this message