摘要:
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
寒云
阅读(5987)
评论(0)
推荐(0)
浙公网安备 33010602011771号