Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dateadd in plsql?

742210Dec 20 2009 — edited Dec 20 2009
I'm in the processw of converting TSQL to PLSQL and come across a slight problem.

DATEADD(MONTH, @months * -1, GETDATE())

Is there a way to do the same thing in plsql, so that I can go back a certain number of months.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2010
Added on Dec 20 2009
2 comments
2,853 views