Re: time conversions

Dale E. Reed Jr. ( (no email) )
Wed, 05 Aug 1998 09:16:01 -0700

Josh Hillman wrote:
> 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.

Not that I know of. You might be able to create a stored procedure
to do it.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |