oracle 查询月份

①:select substr(to_char(sysdate,'yyyy-mm-dd'),6,2) from dual;
②:select to_char(sysdate,'MM') from dual;
原文地址:https://www.cnblogs.com/luxd/p/5976722.html