converting seconds in time format‎

If c1 is always less than 9999 you can use
sel 61 as x,
  cast(cast (x as interval second(4,0)) as interval hour to second(0));

if it's > 9999:
sel 99999 as x,
cast(
     cast (x / 3600 as interval hour(4)) +
     cast (x mod 3600 as interval second(4,0))
as interval day(4) to second(0))

Dieter


http://www.tek-tips.com/viewthread.cfm?qid=505403&page=30

Tweet

Cast Second to HHMMSS

SELECT CAST ((INTERVAL '1000' SECOND) AS INTERVAL HOUR TO SECOND);

Tweet