Convert Seconds to Minutes
-
Guys, is there a way to add a new column to show HH-MM-SS ( as per below example). In excel for example i would simply divide the seconds by 86400 and change the format in the column to hh-ss-mm.
IF OBJECT_ID('tempdb..#Log') IS NOT NULL DROP TABLE #Log
SELECT * INTO #Log FROM (VALUES
( '10', 'Dave', '64131', '92'),
( '11', 'Jim', '64132', '238'),
( '12', 'Steve', '64133', '185')) d
( SEQ, NAME, REF, Seconds)
SELECT * FROM #Log
-
Closing
Viewing 3 posts - 1 through 2 (of 2 total)
The topic ‘Convert Seconds to Minutes’ is closed to new replies.