Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Convert for hh:mm:ss

    Try using the following straight in you dataset for your report:-

    SELECT CONVERT(CHAR(8), DATEADD(SECOND,convert(int, @Seconds), '00:00:00'), 108)

    Had to convert the 2nd DATEADD argument to INT else an error was thrown

Viewing post 1 (of 2 total)