phatmatt2

DELIMITER |
CREATE FUNCTION F_AS_DATE_2 (return_date DATE)
  RETURNS VARCHAR(20)
   DETERMINISTIC
    BEGIN
     DECLARE sf_value VARCHAR(20);
        sf_value = DATE_FORMAT(STR_TO_DATE(DATE,'%Y%m%d'),'%m/%d/%Y');
     RETURN sf_value;
    END|