T-SQL isn't very good with formating data. Usualy it can be done much easier in frontend.
DECLARE @it int
SET @it = 64116
SELECT STUFF(STUFF(RIGHT('000000' + CAST(@it AS varchar(10)),6), 3,0, ':'), 6,0, ':')
>
> I have a field(Integer) and i want to convert it to time using select Statement.
>Example - 64116
>output will be - 06:41:16
--sb--