SELECT DAYS(TIMESTAMP('2006-10-10 00:00:00.0')) - DAYS(TIMESTAMP('2006-4-13 00:00:00.0')) FROM DUAL;
----当前日期减去180天后的日期
SELECT current date - 180 DAYS FROM sysibm.sysdummy1;
------返回()中日期是当年的第几天
SELECT DAYOFYEAR('2006-1-1') FROM sysibm.sysdummy1;
------返回()中日期是当年的第几周
SELECT WEEK('2006-11-30') FROM sysibm.sysdummy1;
---
select TO_CHAR_ORA(SYSDATE(),'mm') from dual;
--------------
select TO_CHAR_ORA(SYSDATE(),'dd') from dual;
--------------
SELECT TO_CHAR_ORA(SYSDATE(),'YYYY-MM-DD') FROM DUAL;
--------------
select TO_CHAR_ORA(SYSDATE(),'yyyy') from dual;