1.在给定时间上加减天数 SQL> select to_char(to_date('20170531000000','yyyymmdd HH24:MI:SS')+4,'YYYYMMDDHH24MISS' )from dual ; ---->20170604000000 2.在给定时间上加减小时数 SQL>select to_char(to_date('20170531000000','yyyymmdd HH24:MI:SS')+2/24,'YYYYMMDDHH24MISS') from dual; ---->20170531020000 总结:sysdate+1 加一天,sysdate+1/24 加一小时,sysdate+1/(24*60) 加一分钟
|