Re: PL/SQL: Add One Month to a Date Variable???
Date: 1997/10/08
Message-ID: <01bcd3f1$ad114320$95761995_at_aohemd4berarb.DaytonOH.NCR.COM>#1/1
The following should work:
t_date := ADD_MONTHS(t_date,1)
Something you need to keep in mind is that ADD_MONTHS will round off to the
last day of the month. For example if you add 2 months to 31-DEC-97, you
will get
28-FEB-98.
Suzanne M Rose
Application Development Consultant
NCR
René Schutte <Rene_at_webhost.co.za> wrote in article
<343B6EF2.960EB48B_at_webhost.co.za>...
> Hi there,
>
> I sincerely hope anyone can help me with this simple query.
>
> If I have declared:
> t_date date;
> and I do the following:
> t_date := t_date + 1;
> I get the date increased by ONE DAY (the default, as I understand it)
>
> I would like to add ONE MONTH to the value of t_date, and as I
> understand it, there is a function that allows you to do this. I don't
> know what the function's name is, and I don't know the syntax for it.
>
> Can anyone help????
>
>
>
>
Received on Wed Oct 08 1997 - 00:00:00 CEST