Skip to Main Content

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!

Sysdate minus one month.

user452402Jun 21 2009 — edited May 30 2012
Good morning Guru,

Oracle 8.1.5

I want to get last year date from current date.
ex. if today is June 21 2009, I want to get June 21 2008.
How to do it the easiest way ?

if sysdate plus one year I know :
select add_months(sysdate,12) from dual

but I couldn't find something like minus_months function.

Can Somebody help ?

thank's
Cabe
This post has been answered by Walter Fernández on Jun 21 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2012
Added on Jun 21 2009
6 comments
233,959 views