(sysdate -1) 减一天 (sysdate_7)一星期 addtime - to_date('2005-03-05' , 'yyyy-MM-dd') 转载于:https://www.cnblogs.com/T_98Dsky/archive/2005/04/20/141294.html