sys@HUIYI(192.168.1.222)> l
1 select sysdate,
2 sysdate + interval '1-1' year to month col01,
3 sysdate + interval '1 1:1:1' day to second col02,
4 sysdate + interval '1-1' year to month + interval '1 1:1:1' day to second col03
5* from dual
sys@HUIYI(192.168.1.222)> /
SYSDATE COL01 COL02 COL03
------------------- ------------------- ------------------- -------------------
2008-09-03 14:28:40 2009-10-03 14:28:40 2008-09-04 15:29:41 2009-10-04 15:29:41
Elapsed: 00:00:00.01
1 select sysdate,
2 sysdate + interval '1-1' year to month col01,
3 sysdate + interval '1 1:1:1' day to second col02,
4 sysdate + interval '1-1' year to month + interval '1 1:1:1' day to second col03
5* from dual
sys@HUIYI(192.168.1.222)> /
SYSDATE COL01 COL02 COL03
------------------- ------------------- ------------------- -------------------
2008-09-03 14:28:40 2009-10-03 14:28:40 2008-09-04 15:29:41 2009-10-04 15:29:41
Elapsed: 00:00:00.01