求一个很简单的SQL语句

[njuzgj]

SQL SERVER里的取当前日期与三个月前的日期的语句是

select * from table
where time>datediff(month,-3,getdate())

请问在ORACLE里该怎么写啊?

[echop]

select add_months(sysdate,-3) from dual;

[小李木耳]

select sysdate,add_months(sysdate,-3) from dual;

年月日：
select to_char(sysdate,'YYYYMMDD'),to_char(add_months(sysdate,-3),'YYYYMMDD') from dual;

[echop]

也可以这么写
select add_months(trunc(sysdate),-3) from dual;