Re: PL/SQL Adding One Month to a Date

René Schutte wrote:
>
> 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????

Try..

        ADD_MONTHS(d,x)
Returns the date d plus x months, x can be any integer -Dave G. Received on Wed Oct 08 1997 - 00:00:00 CDT