SQL> select sysdate from dual;SYSDATE
---------
15-JUN-05SQL> select sysdate + 3*365 +1 from dual;SYSDATE+3
---------
15-JUN-08
---------
15-JUN-05SQL> select sysdate + 3*365 +1 from dual;SYSDATE+3
---------
15-JUN-08
-------------------
2008-06-15 16:56:19已用时间: 00: 00: 02.23
SQL>
select sysdate + 1/24 from dual;
依此类推
select sysdate + interval '3-2' year to month from dual
加10天2小时10分
select sysdate + interval '10 2:10' day to minute from dual