sql 将秒数转换为小时:分:秒 Convert seconds to Hour:Minute:Second

------------------------------------------------------         
-- Usage: Convert seconds to Hour:Minute:Second
------------------------------------------------------          
create  function f_SecondsToHourMinuteSecond(@seconds bigint)         
returns varchar(20)         
as         
begin         
  declare @str as varchar(20) 
  if @seconds >= 10  --如果秒数大于等于10
  begin 
    declare @hour as varchar(10)
    declare @minute as varchar(10)
    declare @second as varchar(10)
    if(@seconds/3600 < 10)
      begin
        set @hour = '0' + convert(varchar(10),@seconds/3600)
      end
    else
      begin
        set @hour = convert(varchar(10),@seconds/3600)
      end
   
    if(@seconds%3600/60 < 10)
      begin
         set @minute = '0' + convert(varchar(10),@seconds%3600/60)
      end
    else
      begin
         set @minute = convert(varchar(10),@seconds%3600/60)
      end

    if(@seconds%3600%60 < 10)
      begin
         set @second = '0' + convert(varchar(10),@seconds%3600%60%60)
      end
    else
      begin
         set @second = convert(varchar(10),@seconds%3600%60%60)
      end
    set @str = @hour + ':' + @minute + ':' + @second
  end 
  else   --如果秒数小于10
  begin 
     set @str = '00:00:0'+convert(varchar(20),@seconds) 
  end 
    return(@str)       
end