Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: GetDateInString

    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

Viewing post 1 (of 1 total)