CREATE FUNCTION [dbo].[DateFormate] (@input Date) RETURNS NVARCHAR(50) AS BEGIN DECLARE @Date NVARCHAR(50) SET @Date = CONVERT(NVARCHAR,@input, 103) RETURN @Date END
CREATE FUNCTION DateFormate(@input Date) RETURNS NVARCHAR(50) AS BEGIN DECLARE @Date NVARCHAR(50) SET @Date = Format(@input, 'dd-MM-yyyy') RETURN @Date END
0 Comments