Mavengers
Developer's Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment