PL/SQL: Add One Month to a Date Variable???

From: (wrong string) é Schutte <Rene_at_webhost.co.za>
Date: 1997/10/08
Message-ID: <343B6EF2.960EB48B_at_webhost.co.za>#1/1


[Quoted] Hi there,

[Quoted] 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

Original text of this message