Thursday, June 11, 2015

SQL Convert decimal time to hours and minutes

DECLARE @f FLOAT = 13.5;

SELECT CONVERT(TIME(0), DATEADD(MINUTE, 60*@f, 0));

No comments:

Post a Comment