Home Forums SQL Server 2014 Development - SQL Server 2014 Query issue 2 RE: Query issue 2

  • August 29, 2013 at 6:11 am

    #1645938

    Here is the corrected statement:

    SET @StartDate = convert(VARCHAR(10), getdate(), 101)

    + ' ' + (CAST(DATEPART(hh, (SELECT [Value] FROM tbltime WHERE NAME='TIME')) AS VARCHAR)

    + ':' + CAST(DATEPART(mi, (SELECT [Value] FROM tbltime WHERE NAME='TIME')) AS VARCHAR)

    + ':' + CAST(DATEPART(ss, (SELECT [Value] FROM tbltime WHERE NAME='TIME')) AS VARCHAR)

    -- unmark the line below if you want to display the miliseconds in the result

    --+ '.' + CAST(DATEPART(ms, (SELECT [Value] FROM tbltime WHERE NAME='TIME')) AS VARCHAR)

    )

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **