Date functions in Sql server

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

Post a Comment

0 Comments