没有
16:05:53 SQL> select to_date(to_char(sysdate,'yyyy')+5||to_char(sysdate,'mmdd hh24miss'),
16:30:03 2 'yyyymmddhh24miss'), sysdate from dual;TO_DATE(TO SYSDATE
---------- ----------
13-9月 -09 13-9月 -04已用时间: 00: 00: 00.19
16:30:22 SQL>
16:05:53 SQL> select to_date(to_char(sysdate,'yyyy')+5||to_char(sysdate,'mmdd hh24miss'),
16:30:03 2 'yyyymmddhh24miss'), sysdate from dual;TO_DATE(TO SYSDATE
---------- ----------
13-9月 -09 13-9月 -04已用时间: 00: 00: 00.19
16:30:22 SQL>
-------------------
2004-09-13 16:38:35已用时间: 00: 00: 00.16
16:41:31 SQL> select add_months(sysdate,5*12) from dual;ADD_MONTHS(SYSDATE,
-------------------
2009-09-13 16:38:41已用时间: 00: 00: 00.00
都是不错的想法!
CURRENT_DA CURRENT_DA
---------- ----------
16-9月 -04 16-10月-05
SELECT current_date,current_date + TO_YMINTERVAL('-1-1') FROM dual;
CURRENT_DA CURRENT_DA
---------- ----------
16-9月 -04 16-8月 -03 select current_date,current_date+to_yminterval('1-0') from dual;
CURRENT_DA CURRENT_DA
---------- ----------
16-9月 -04 16-9月 -05