time conversions

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Ray Carpenter: "Fwd: Emerald & ASP"
Next message: Josh Hillman: "Re: Ascend Fatal Error and Calls OnLine"
Next in thread: Dale E. Reed Jr.: "Re: time conversions"

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
hillman@talstar.com

Previous message: Ray Carpenter: "Fwd: Emerald & ASP"
Next message: Josh Hillman: "Re: Ascend Fatal Error and Calls OnLine"
Next in thread: Dale E. Reed Jr.: "Re: time conversions"