Home Forums SQL Server 2005 T-SQL (SS2K5) How to convert INTEGER to TIME RE: How to convert INTEGER to TIME
gyessql
Ten Centuries
Points: 1097
More actions
February 13, 2009 at 12:13 pm
#943877
declare @time int
set @time = 70
select cast((@time / 60) as varchar(2)) + ':' + cast((@time % 60) as varchar(2))