time conversions

Josh Hillman ( (no email) )
Wed, 5 Aug 1998 10:41:30 -0400

Is there a way to take an integer like 8625 (representing seconds) and
convert it into something like "2:23:45" using SQL? If at all possible,
I'd like to use this in one of my scripts to show the integer
AcctSessionTime as hours:minutes:seconds (VarChar, I guess). If
AcctSessionTime were some form of Date/Time it would be easy using
CONVERT(whatever), but realistically, it makes sense that it's an integer.

Josh Hillman