Posted by 민서정
l

 CREATE OR REPLACE FUNCTION
       F_Get_day2YYMMDD(In_date CHAR)
       RETURN CHAR IS Out_yymmdd VARCHAR2(50);
      
/* 과거 시점부터 현재일까지의 일수를 년월일로 반환*/
      
Begin
  SELECT  TRUNC (mb / 12) || '년'
       ||TRUNC (MONTHS_BETWEEN (SYSDATE
                               , ADD_MONTHS ( to_date(In_date,'yyyymmdd'), 12 * TRUNC (mb / 12))
                                )
                )
       || '개월'
       ||TRUNC (SYSDATE - ADD_MONTHS ( to_date(In_date,'yyyymmdd'), TRUNC (mb))) || '일' yymmdd
  into Out_yymmdd
    
  FROM (SELECT MONTHS_BETWEEN (SYSDATE, to_date(In_date,'yyyymmdd')) mb FROM dual);
 
 
   Return (Out_yymmdd);
  
  
Exception
     WHEN NO_DATA_FOUND THEN
      RETURN null;
End F_Get_day2YYMMDD;
Posted by 민서정
l

RGB 추출유틸
Posted by 민서정
l