1.在日期后直接加上你要加的日期数
如:
SQL> select sysdate from dual;
SYSDATE
---------
26-MAY-05
SQL> select sysdate+10 from dual;
SYSDATE+1
---------
05-JUN-05
2.如果想要加的是分钟,只需将分钟除以1440后再与之相加
如:
SQL> select to_char(sysdate,'DD-MON-RR HH:MI:SS') NOW,
2 to_char(sysdate+10/1440,'DD-MON-RR HH:MI:SS') NEWTIME from dual;
NOW NEWTIME
------------------ ------------------
26-MAY-05 05:04:16 26-MAY-05 05:14:16
3.至于加上小时或秒,改为除以24或86400再与之相加即可
4.如果想要加的是月数,可以用ADD_MONTHS函数
如:
SQL> select add_months(sysdate,6) from dual;
ADD_MONTH
---------
26-NOV-05
5.如果想要加日,小时,分,秒,可以用TO_DSINTERVAL(..)函数
如:
SQL> SELECT CURRENT_TIMESTAMP, (CURRENT_TIMESTAMP + TO_DSINTERVAL('1 00:00:00')) "New Time" FROM dual;
CURRENT_TIMESTAMP New Time
-------------------------------------------------- --------------------------------------------------
17-JUN-05 02.05.10.282848 PM +08:00 18-JUN-05 02.05.10.282848000 PM +08:00
如:
SQL> select sysdate from dual;
SYSDATE
---------
26-MAY-05
SQL> select sysdate+10 from dual;
SYSDATE+1
---------
05-JUN-05
2.如果想要加的是分钟,只需将分钟除以1440后再与之相加
如:
SQL> select to_char(sysdate,'DD-MON-RR HH:MI:SS') NOW,
2 to_char(sysdate+10/1440,'DD-MON-RR HH:MI:SS') NEWTIME from dual;
NOW NEWTIME
------------------ ------------------
26-MAY-05 05:04:16 26-MAY-05 05:14:16
3.至于加上小时或秒,改为除以24或86400再与之相加即可
4.如果想要加的是月数,可以用ADD_MONTHS函数
如:
SQL> select add_months(sysdate,6) from dual;
ADD_MONTH
---------
26-NOV-05
5.如果想要加日,小时,分,秒,可以用TO_DSINTERVAL(..)函数
如:
SQL> SELECT CURRENT_TIMESTAMP, (CURRENT_TIMESTAMP + TO_DSINTERVAL('1 00:00:00')) "New Time" FROM dual;
CURRENT_TIMESTAMP New Time
-------------------------------------------------- --------------------------------------------------
17-JUN-05 02.05.10.282848 PM +08:00 18-JUN-05 02.05.10.282848000 PM +08:00