How would you convert secs to HH:MM:SS format in SQLite?

Question

How would you convert secs to HH:MM:SS format in SQLite?

Answer 1

Well, i would do something like this, but i'm getting hours plus 12...

SELECT strftime('%H-%M-%S', CAST(<seconds here> / 86400.0 AS DATETIME)) 

-- For subtracting the 12 hours difference :S
SELECT strftime('%H-%M-%S', CAST(<seconds here> / 86400.0 AS DATETIME) - 0.5) 

Answer 2

Try this one:

sqlite> SELECT time(10, 'unixepoch');
00:00:10