Home Forums SQL Server 2008 SQL Server Newbies Decimal Hours Duration to HH:MM RE: Decimal Hours Duration to HH:MM

  • August 30, 2012 at 7:14 am

    #1531860

    declare @time decimal(5,2);

    set @time = 95.25;

    select cast(@time as int)+(((@time-cast(@time as int))*.60));