摘要： select abs(trunc(sysdate,'MM')-trunc(TO_DATE('2010-10-11','YYYY-MM-DD'),'MM')) from dual;相当于sql datediff(m,...) SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL; return Current Year SELECT EXTRACT(MONTH... 阅读全文