addmonth.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 14 行

SELECT ADD_MONTHS('28-2月-00', 1) FROM DUAL;
SELECT ADD_MONTHS('28-2月-00', -1) FROM DUAL;
SELECT ADD_MONTHS('29-2月-00', 1) FROM DUAL;


SELECT ADD_MONTHS(SYSDATE,1) FROM DUAL;
SELECT ADD_MONTHS(SYSDATE,12) FROM DUAL;

SELECT ADD_MONTHS('28-11月-00', 1) FROM DUAL;
SELECT ADD_MONTHS('29-11月-00', 1) FROM DUAL;
SELECT ADD_MONTHS('30-11月-00', 1) FROM DUAL;
SELECT ADD_MONTHS('31-12月-00', -1) FROM DUAL;