[FUNCTION]GET_ZERODATE

CREATE OR REPLACE FUNCTION SAPHEE.GET_ZERODATE (IN_DATE VARCHAR2 )

RETURN  VARCHAR2 IS  RT VARCHAR2(8);

BEGIN

 RT := IN_DATE;
  IF IN_DATE = '00000000' THEN RT := '';
  END IF;

  IF IN_DATE = '000000' THEN RT := '';
  END IF;

  RETURN RT;

END;
/