DB2.Funciton - 특정일자에_format지정하기

[ DB2.Funciton - 특정일자에_format지정하기 ]

 

* 해당일자를 DATE 일자로 반환됩니다.(YYYYMMDD ==> YYYY-MM-DD)' *

SET SCHEMA MISADM;

 

SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","MISADM";

 

CREATE FUNCTION COM.GET_DATE_DD

 (ASDATE VARCHAR(8)

 )

  RETURNS CHARACTER(10)

  SPECIFIC COM.GET_DATE_DD

  LANGUAGE SQL

  DETERMINISTIC

  READS SQL DATA

  STATIC DISPATCH

  CALLED ON NULL INPUT

  EXTERNAL ACTION

  INHERIT SPECIAL REGISTERS

  BEGIN ATOMIC

    DECLARE vReturn CHARACTER(10);

    SET vReturn = (

      SELECT CHAR(DATE(SUBSTR(asDate,1,4) ||'-'|| SUBSTR(asDate,5,2) ||'-'||

          SUBSTR(asDate,7,2)))

        FROM COM.Z_COMCDCOD_TBL

        FETCH FIRST 1 ROWS ONLY ) ;

    IF vReturn IS NULL THEN

      SET vReturn = '';

    END IF;

    RETURN vReturn;

  END;

 

COMMENT ON FUNCTION COM.GET_DATE_DD

 (VARCHAR(8)

 )

  IS '해당일자를 DATE 일자로 반환됩니다.(YYYYMMDD ==> YYYY-MM-DD)';