1.求某个日期所在月份的总天数
SELECT TO_NUMBER(TO_CHAR(LAST_DAY(TO_DATE('20080801','YYYYMMDD')),'dd')) FROM DUAL;
2.函数可以得到两个日期之间的天数
select trunc(sysdate-to_date('20080830','yyy
1.求某个日期所在月份的总天数
SELECT TO_NUMBER(TO_CHAR(LAST_DAY(TO_DATE('20080801','YYYYMMDD')),'dd')) FROM DUAL;
2.函数可以得到两个日期之间的天数
select trunc(sysdate-to_date('20080830','yyyymmdd')) from dual;
select trunc(sysdate-to_date('2008-08-30','yyyy-mm-dd')) from dual;
Select Floor(B-A) From Tab_Name
3.求某个日期所在月份的最後一天
SELECT TO_NUMBER(TO_CHAR(LAST_DAY(TO_DATE('20080801','YYYYMMDD')),'YYYYMMdd')) INTO VEND_DAY FROM DUAL;