Re: time conversions

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

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

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.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

Previous message: Josh Hillman: "Re: Ascend Fatal Error and Calls OnLine"
Next message: Dale E. Reed Jr.: "Re: Fwd: Emerald & ASP"
Maybe in reply to: Josh Hillman: "time conversions"
Next in thread: William Salame: "Re: time conversions"