BEGIN
DBMS_OUTPUT.PUT_LINE(
'两个日期之间的差异月份:'||MONTHS_BETWEEN('1995-01-01','1994-11-01')
);
DBMS_OUTPUT.PUT_LINE(
'向指定日期添加月份:'||ADD_MONTHS(SYSDATE,6);
);
DBMS_OUTPUT.PUT_LINE(
'下个星期五为:'||NEXT_DAY(SYSDATE,'星期五');
);
DBMS_OUTPUT.PUT_LINE(
'显示当前月的最后1天:'||LAST_DAY(SYSDATE);
);
DBMS_OUTPUT.PUT_LINE(
'两个日期之间的差异月份:'||MONTHS_BETWEEN('1995-01-01','1994-11-01')
);
DBMS_OUTPUT.PUT_LINE(
'向指定日期添加月份:'||ADD_MONTHS(SYSDATE,6);
);
DBMS_OUTPUT.PUT_LINE(
'下个星期五为:'||NEXT_DAY(SYSDATE,'星期五');
);
DBMS_OUTPUT.PUT_LINE(
'显示当前月的最后1天:'||LAST_DAY(SYSDATE);
);
END;
SELECT TRUNC(SYSDATE,'MONTH'),
ROUND(SYSDATE,'YEAR'),
ROUND(SYSDATE,'DAY'),
TRUNC(SYSDATE,'YEAR'),
TRUNC(SYSDATE,'DAY'),
TRUNC(SYSDATE,'HH24'),
TRUNC(SYSDATE,'MI')
FROM DUAL
TRUNC(SYSDATE,'MONTH') ROUND(SYSDATE,'YEAR') ROUND(SYSDATE,'DAY') TRUNC(SYSDATE,'YEAR') TRUNC(SYSDATE,'DAY') TRUNC(SYSDATE,'HH24') TRUNC(SYSDATE,'MI')
2013/09/01 2014/01/01 2013/09/22 2013/01/01 2013/09/22 2013/09/22 17:00:00 2013/09/22 17:55:00