2013年3月8日
摘要: V_DATE DATE; SELECT TRUNC(SYSDATE,'MM') INTO V_DATE FROM DUAL;SELECT LAST_DAY(SYSDATE) INTO V_DATE FROM DUAL;SELECT TRUNC(ADD_MONTHS(SYSDATE,-1),'MM') INTO V_DATE FROM DUAL;SELECT LAST_DAY(ADD_MONTHS(SYSDATE,-1)) INTO V_DATE FROM DUAL;SELECT TRUNC(ADD_MONTHS(SYSDATE,-11),'MM' 阅读全文
posted @ 2013-03-08 10:48 寒云 阅读(5930) 评论(0) 推荐(0) 编辑