The Convertion of Minutes to TIME is not possible
directly..
DECLARE @Minutes INT = 606
SELECT CAST( @Minutes AS TIME) [TimeInHH:Mi:SS.nnnnnn]
Gives the below error,
Msg 529, Level 16, State 2, Line 3
Explicit conversion from data type int to time is not allowed.
Solution:
DECLARE @Minutes INT = 606
SELECT CAST( DATEADD( Mi, @Minutes, '1900-01-01') AS TIME)
TimeInHH:Mi:SS.nnnnnn
----------------------
10:06:00.0000000