Why wait when I can write it my self......Here is a function to convert the seconds to DD:HH:MM:SS
now still wondering if I can toggle or if a new report will be needed.
CREATE FUNCTION [dbo].[TimeConvert] (@SecIn int)
RETURNS char(11)
AS
Begin
declare @daysint
declare @hours int
declare @min-2 int
declare @sec int
declare @timeOut varchar(11)
--************ days *************
set @days = @secIn / 86400 -- as Days
If @days > 9
Set @timeout = convert(char(2), @days) + ':'
else
if @days > 0
Set @timeout = '0' + convert(char(1), @days) + ':'
else
Set @timeout = '00:'
set @days = @days * 86400
--************ hours *************
set @hours = (@secIn - @days) / 3600 --as Hours
If @hours > 9
Set @timeout = @timeout + convert(char(2), @hours) + ':'
else
if @hours > 0
Set @timeout = @timeout + '0' + convert(char(1), @hours) + ':'
else
Set @timeout = @timeout + '00:'
set @hours = @hours * 3600
--**************** min ****************
set @min-2 = (@secIn - @days - @hours) / 60 --as Hours
If @min-2 > 9
Set @timeout = @timeout + convert(char(2), @min-2) + ':'
else
if @min-2 > 0
Set @timeout = @timeout + '0' + convert(char(1), @min-2) + ':'
else
Set @timeout = @timeout + '00:'
--**************** sec ****************
set @sec = (@secIn - @days - @hours - @min-2 )
If @sec > 9
Set @timeout = @timeout + convert(char(2), @sec)
else
if @sec > 0
Set @timeout = @timeout + '0' + convert(char(1), @sec)
else
Set @timeout = @timeout + '00'
Return(@timeout)
END;
GO
-- select dbo.TimeConvert(123456)
-- select dbo.TimeConvert(123456)
-- select dbo.TimeConvert(123456)
-- select dbo.TimeConvert(123456)
-- select dbo.TimeConvert(123456)
-- select dbo.TimeConvert(123456)