select * from dual where sysdate >add_months(sysdate-2,-1) and sysdate<sysdate-1楼主对照改,关键是add_months()函数用法 ,可以g.cn下
取得上月22号的时间SELECT ADD_MONTHS(TO_DATE('22','DD'),-1) FROM DUAL;取得现在的23号的时间SELECT TO_DATE('23','DD') FROM DUAL; 两个时间的月份差SELECT MONTHS_BETWEEN( TO_DATE('23','DD'), ADD_MONTHS(TO_DATE('22','DD'),-1) ) FROM DUAL;两个时间的天数差 SELECT TO_DATE('23','DD') - ADD_MONTHS(TO_DATE('22','DD'),-1) FROM DUAL;
* from dual
where sysdate >add_months(sysdate-2,-1) and sysdate<sysdate-1楼主对照改,关键是add_months()函数用法 ,可以g.cn下
两个时间的月份差SELECT MONTHS_BETWEEN(
TO_DATE('23','DD'),
ADD_MONTHS(TO_DATE('22','DD'),-1)
)
FROM DUAL;两个时间的天数差
SELECT TO_DATE('23','DD') - ADD_MONTHS(TO_DATE('22','DD'),-1)
FROM DUAL;