select sysdate - interval '7' day from dual
select to_date(to_char(sysdate,'yyyy-mm-dd hh:mi:ss'),'yyyy-mm-dd hh:mi:ss') from dual;
select to_char(sysdate - interval '6' day, 'YYYYMMDD') from dual;
另附:
当前时间减去7分钟的时间
select sysdate - interval '7' day from dual
select to_date(to_char(sysdate,'yyyy-mm-dd hh:mi:ss'),'yyyy-mm-dd hh:mi:ss') from dual;
select to_char(sysdate - interval '6' day, 'YYYYMMDD') from dual;
另附:
当前时间减去7分钟的时间