CREATE FUNCTION GetTime
(
@Seconds int
)
RETURNS varchar(100)
AS
BEGIN
DECLARE @TimeVal varchar(100),@dateVal datetime
SET @dateVal = DATEADD(ss,@Seconds,0)
SET @TimeVal = CAST(DATEDIFF(dd,0,@dateVal)* 24 + DATEPART(hh,@dateVal) AS varchar(5)) + ':' + DATENAME(n,@dateVal) + ':' + DATENAME(ss,@DateVal)
RETURN @TimeVal
END
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
convert
Posted - 12/20/2012 : 14:26:44
