欧博娱乐Convert Seconds to Minutes – SQLServerCe

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

2026-01-08 01:38 点击量：2