SELECT to_date('2006-11-7','YYYY-MM-DD')+1 FROM DUAL;--加上一天后为2006-11-8
select add_months(to_date('2006-11-17','yyyy-mm-dd'),36)-1 "Three years Later" from dual; select to_char(add_months(to_date('2006-11-17','yyyy-mm-dd'),36)-1,'yyyy-mm-dd') "Three years Later" from dual;
select add_months(to_date('2006-11-17','yyyy-mm-dd'),3*12)+1 newdate from dual
2006-11-17 原来就是日期 还是to_date 吗
是的, add_months是日期函数!
原来就是日期,就不需要to_date 例如 select add_months(sysdate,3*12)-1 newdate from dual
是什么意思?
select add_months(to_date('2006-11-17','yyyy-mm-dd'),3*12)+1 newdate from dual
?这样
from dual;
select to_char(add_months(to_date('2006-11-17','yyyy-mm-dd'),36)-1,'yyyy-mm-dd') "Three years Later"
from dual;
例如
select add_months(sysdate,3*12)-1 newdate from dual