DB2 存储过程的一些公用方法
--本月月份
SET V_STAT_MONTH = CHAR(SUBSTR(IC_STAT_DATE,1,6)); --本月yyyy-mm-dd SET V_STAT_DATE_1 = CHAR(SUBSTR(IC_STAT_DATE,1,4)||'-'||SUBSTR(IC_STAT_DATE,5,2)||'-'||SUBSTR(IC_STAT_DATE,7,2)); --前一天 SET V_YESTER_DAY_1 = CHAR(SUBSTR(CHAR(XJDSS.CHAR2DATE(IC_STAT_DATE) - 1 DAY),1,10)); SET V_YESTER_DAY = SUBSTR(V_YESTER_DAY_1,1,4)||SUBSTR(V_YESTER_DAY_1,6,2)||SUBSTR(V_YESTER_DAY_1,9,2); --六个月前月份 SET V_LAST_MOMTH6 = SUBSTR(CHAR(XJDSS.CHAR2DATE(IC_STAT_DATE) - 6 MONTH),1,4)||SUBSTR(CHAR(XJDSS.CHAR2DATE(IC_STAT_DATE) - 6 MONTH),6,2); CALL XJDSS.SP_GET_VALUE_FROM_DATE(IC_STAT_DATE,'DD',V_DAY); CALL XJDSS.SP_GET_VALUE_FROM_DATE(IC_STAT_DATE,'MM',V_MONTH); CALL XJDSS.SP_GET_VALUE_FROM_DATE(IC_STAT_DATE,'YYYY',V_YEAR); CALL XJDSS.SP_GET_VALUE_FROM_DATE(IC_STAT_DATE,'MM%3',V_MONTH_NUMBER); CALL XJDSS.SP_GET_VALUE_FROM_DATE(IC_STAT_DATE,'YY%2',V_YEAR_NUMBER); |
|