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