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 ;
