date型別

如下建議：
1、使用numtodsinterval內建函式增加小時、分鐘和秒
2、加一個簡單的數增加天
3、使用add_months內建函式增加月和年

測試
JEL@JEL >alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';

Session altered.

JEL@JEL >select sysdate from dual;

SYSDATE
-------------------
20-12-2013 20:43:20

JEL@JEL >select sysdate+numtodsinterval(100,'second') from dual;

SYSDATE+NUMTODSINTE
-------------------
20-12-2013 20:45:30

JEL@JEL >select sysdate+numtodsinterval(100,'minute') from dual;

SYSDATE+NUMTODSINTE
-------------------
20-12-2013 22:24:19

JEL@JEL >select sysdate+numtodsinterval(100,'hour') from dual;

SYSDATE+NUMTODSINTE
-------------------
25-12-2013 00:44:38

JEL@JEL >select sysdate + 1 from dual;

SYSDATE+1
-------------------
21-12-2013 20:44:50

JEL@JEL >select add_months(sysdate,1) from dual;

ADD_MONTHS(SYSDATE,
-------------------
20-01-2014 20:45:17