Oracle 日期类型数据加减

1、最常见的方式

select sysdate "当前时间",
sysdate-1 "当前时间减1天",
sysdate+1 "当前时间加1天",
sysdate-1/24 "当前时间减1小时",
sysdate-1/24/60 "当前时间减1分钟",
sysdate-1/24/60/60 "当前时间减1秒"
from dual;

2、使用系统函数

#为了看出效果将sysdate改为systimestamp 
select sysdate "当前时间",
systimestamp -numtodsinterval(1,'day') "当前时间减1天",
systimestamp+numtodsinterval(1,'day') "当前时间加1天",
systimestamp-numtodsinterval(1,'hour') "当前时间减1小时",
systimestamp-numtodsinterval(1,'minute') "当前时间减1分钟",
systimestamp-numtodsinterval(1,'second') "当前时间减1秒"
from dual;