比如說取得當前日期的月份為select extract(month from sysdate) from dual,當然,也可以先把日期轉換這字符型,再用substr,比如,select to_number(substr(to_char(sysdate,'yyyymmdd'),5,6)),可以達到同extract()相同的效果
用to_char就可以了。 select to_char(sysdate,'mm') from dual;
最简单的方法是: select to_char(sysdate,'MM') from dual;
SQL> SELECT TO_CHAR(SYSDATE,'MON','NLS_DATE_LANGUAGE=AMERICAN') FROM DUAL;TO_ --- OCT或: SQL> SELECT TO_CHAR(SYSDATE,'MON') FROM DUAL;TO_C ---- 10月
select to_char(sysdate,'mm') from dual;
select to_char(sysdate,'MM') from dual;
---
OCT或:
SQL> SELECT TO_CHAR(SYSDATE,'MON') FROM DUAL;TO_C
----
10月
select to_char(sysdate,'MM') from dual;