Sysdate minus one month.
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