Oracle database time a year ago one months before the day before

1. Get the date a week before the current time


Select Sysdate-interval ' 7 ' from dual

Similar to
Current time minus 7 minutes of time
Select Sysdate,sysdate-interval ' 7 ' MINUTE from dual
The current time minus 7 hours of time
Select Sysdate-interval ' 7 ' hour from dual
The current time minus 7 days
Select Sysdate-interval ' 7 ' from dual
Current time minus July time
Select Sysdate,sysdate-interval ' 7 ' month from dual
The current time minus 7 years time
Select Sysdate,sysdate-interval ' 7 ' from dual
Time interval multiplied by a number
Select Sysdate,sysdate-8 *interval ' 2 ' hour from dual

2, get the current time one months ago date
Select Add_months (sysdate,-1) from dual
3. Get the date of the current time one year ago


Select Add_months (sysdate,-12) from dual