Home Forums SQL Server 2005 T-SQL (SS2K5) converting milliseconds RE: converting milliseconds
Samuel Vella
SSCrazy Eights
Points: 8055
More actions
February 25, 2009 at 2:14 am
#949839
declare @milli as int
set @milli = 11202079
select @milli/3600000 as hours,
(@milli - ((@milli/3600000)*3600000))/60000 as minutes,
(@milli - (((@milli)/60000)*60000)) /1000 as seconds,
@milli-(((@milli)/1000)*1000) as milliseconds