example from project
|
1 2 3 4 |
select 4827 div 60 div 60 into @h; select (4827-@h*60*60) div 60 into @m; select (4827-(@h*60*60)-(@m*60)) into @s; select @h,@m,@s; |
elementary, but in practice…
or just
select SEC_TO_TIME(4827);