Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Adding One Month to a Date
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 CDT
![]() |
![]() |