最近三个月: select add_months(sysdate,-3)) from dual;
最近90天: select to_char(sysdate-90,'yyyy-MM-dd') from dual;
最近三个月: select add_months(sysdate,-3)) from dual;
最近90天: select to_char(sysdate-90,'yyyy-MM-dd') from dual;
转载于:https://www.cnblogs.com/yangsongyan/p/9502974.html