Home Forums SQL Server 2008 SQL Server Newbies Decimal Hours Duration to HH:MM RE: Decimal Hours Duration to HH:MM
laurie-789651
SSCertifiable
Points: 7680
More actions
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));