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 12:00 pm

    #943873

    SELECT

    CONVERT(VARCHAR,[Column] / 60) + ':' + RIGHT('00' + CONVERT(VARCHAR,[Column] % 60),2)

    FROM

    [Table]