hi

let me know below query satisfy requirement or not .

thanks

Jayanth

CREATE FUNCTION [Global].[fn_GetDateInString]

(

@InputString AS NVARCHAR(500)

)

RETURNS NVARCHAR(50)

AS

BEGIN

DECLARE @output AS nvarchar(100)

SELECT @output = Convert(varchar,convert(Date, @InputString, 107),107)

return @output

END