mysql秒转时分秒函数

create function SecondToMS(aSecond int)
returns varchar(255)
begin
DECLARE ret varchar(255);
DECLARE tvalue int;
  set ret=CONCAT(floor(mod(aSecond,60)) , '秒');
  set tvalue= floor(aSecond / 60) ;
  if(tvalue>0) then
      if(mod(aSecond,60) <>0) then
        set ret=CONCAT( floor(mod(tvalue, 60)) , '分' , ret);
      else
        set ret= CONCAT(floor(mod(tvalue,60)) , '分');
      end if;
  end if;
  set tvalue= floor(tvalue / 60) ;
  if(tvalue>0) then
       if(mod(tvalue,60) <>0) then
         set ret= CONCAT(floor(tvalue) , '时' , ret);
       else
         set ret= CONCAT(floor(tvalue) , '时');
       end if;
  end if;
  return ret;
end ;