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(), '*')