摘要:
算差月1.select trunc(sysdate) , months_between(trunc(sysdate, 'mm'), trunc(to_date( '2011-2-17', 'YYYY-MM-DD'), 'mm')) from dual2.算差天select trunc(sysdate-to_date('2011-3-10','yyyy-mm-dd')) from dual;3算本月最后一天select trunc(sysdate, 'MONTH') 本月第一天,to_ 阅读全文