Home Forums SQL Server 2005 T-SQL (SS2K5) How to convert INTEGER to TIME RE: How to convert INTEGER to TIME

  • February 13, 2009 at 6:48 pm

    #944006

    pshvets (2/13/2009)

    Hello,

    I have a column which is integer data type and it represents number of seconds.

    I need to convert it into MINUTES:SECONDS format.

    Conversion of int into time is prohibited in SQL server.

    MOD function doesn't seem to work in my SQL Server 2008 installation either

    Could someone suggest how to do that?

    Thanks,

    Pit.

    Do you have an upper limit of 3599 seconds on this? What do you want to display if you hit 3600 seconds? What do you want to display if you hit 86400 seconds?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)