Re: Oracle Dates
From: The Magnet <art_at_unsu.com>
Date: Tue, 5 Jan 2010 18:09:43 -0800 (PST)
Message-ID: <35919c6c-2bf9-4362-bc92-5b99afb10cd4_at_26g2000yqo.googlegroups.com>
On Jan 5, 6:48 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> The Magnet (a..._at_unsu.com) 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')
Date: Tue, 5 Jan 2010 18:09:43 -0800 (PST)
Message-ID: <35919c6c-2bf9-4362-bc92-5b99afb10cd4_at_26g2000yqo.googlegroups.com>
On Jan 5, 6:48 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> The Magnet (a..._at_unsu.com) 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