[MSSQL] 날짜 형식 맞추기

CREATE  FUNCTION dbo.getDateFormat(@p_brand varchar(64), @p_fieldName varchar(64), @p_value datetime)
 RETURNS VARCHAR(4000)
AS
BEGIN
	declare @val varchar(4000)
	declare @format varchar(4000)
	declare @sql varchar(4000)

	set @format=
		(SELECT top 1 TRAN_VALUE 
		  FROM TB_MEMBER_CODETRAN 
		 WHERE BRAND=@p_brand 
			   AND FIELD_NAME=@p_fieldName 
		)
		
	if @format='date' begin
		set @val = (select @p_value)
	end 
	else begin
		set @val = (select dbo.FNDateFormat(convert(varchar(23),@p_value,121),@format))
	end
	return @val
END