主要介绍Oracle对时间操作的内置函数
1.Oracle内部时间:
SYSDATE:
SQL> SELECT SYSDATE FROM DUAL;
SYSDATE
------------------
24-APR-13
CURRENT_DATE:
SQL> SELECT CURRENT_DATE FROM DUAL;
CURRENT_DATE
------------------
24-APR-13
SYSTIMESTAMP:
SQL> SELECT SYSTIMESTAMP FROM DUAL;
SYSTIMESTAMP
---------------------------------------------------------------------------
24-APR-13 11.17.53.448133 AM +08:00
2.Oracle时间内置函数:
2.1ADD_MONTHS增加、减少月份
SQL> SELECT ADD_MONTHS(CURRENT_DATE,4) FROM DUAL;
ADD_MONTHS(CURRENT
------------------
24-AUG-13
SQL> SELECT ADD_MONTHS(CURRENT_DATE,-4) FROM DUAL;
ADD_MONTHS(CURRENT
------------------
24-DEC-12
2.2 GREATEST和LEAST:least从一个日期(不管是列还是日期字面值)表中选择最早的日期,而greatest从一个日期表中选择最近的一个日期。两者如果