SQL Func MyDateFormat

Func MyDateFormat

CREATE FUNCTION MyDateFormat
         (@indate datetime,
          @Separator char(1)='-')
RETURNS nchar(20)
AS
BEGIN
    RETURN 
        CONVERT(nvarchar(20), DATEPART(dd, @indate)) 
        + @Separator 
        + CONVERT(nvarchar(20), DATEPART(mm, @indate)) 
        + @Separator 
        + CONVERT(nvarchar(20), DATEPART(yy, @indate))
END

GO

SELECT dbo.MyDateFormat(GETDATE(), '*')