Introduction :
In this article i will show you how to convert Integer to time format in sql server .I have created function will return time as a string .Its takes parameter as a second in integer and return time .
CREATE function [dbo].[GetMinutesFromInt](@seconds int) returns varchar(20) as
begin
declare @time varchar(20)
set @time = CASE WHEN @seconds/3600<10 THEN '0' ELSE '' END + RTRIM(@seconds/3600) + ':' + RIGHT('0'+RTRIM((@seconds % 3600) / 60),2) + ':' + RIGHT('0'+RTRIM((@seconds % 3600) % 60),2)
return(@time)
end
Call Function :
select dbo.GetMinutesFromInt(70)
Output :
00:01:10
No comments:
Post a Comment