Re: PL/SQL Adding One Month to a Date

On Wed, 08 Oct 1997 13:27:31 +0200, "René Schutte" <Rene_at_webhost.co.za> 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????

How can you hope to effectively code in Oracle without reference documentation? All the PL/SQL functions are listed there. Received on Thu Oct 09 1997 - 00:00:00 CDT