Home Forums Reporting Services Reporting Services Display negative seconds in HH:MM:SS format RE: Display negative seconds in HH:MM:SS format

  • July 28, 2014 at 9:09 am

    #1732885

    Didn't realize that this was for reporting services until I was posting. Maybe this T-SQL code might give you an idea.

    DECLARE @Seconds int = -223

    SELECT CASE WHEN @Seconds < 0 THEN '-' ELSE '' END +

    RIGHT( '0' + CAST( ABS( @Seconds / 3600) AS VARCHAR(2)), 2) + ':' +

    RIGHT( '0' + CAST( ABS( (@Seconds % 3600) / 60) AS VARCHAR(2)), 2) + ':' +

    RIGHT( '0' + CAST( ABS( (@Seconds % 3600) % 60) AS VARCHAR(2)), 2)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2