CREATE FUNCTION change_date_yyyymmdd(@date DATE) RETURNS CHAR(8) AS BEGIN RETURN CONVERT(CHAR(8), @date, 112); END;