way to convert minutes to SQL TIME

[blair]

Hi guys.

I need some way to convert minutes (e.g. 80 mins) to SQL TIME (e.g. 01:20:00) in order to add it to another TIME var.

Is there any way to do this? I really dont want to convert my whole db. Basically, I want to do: e.g. 80 + 10:00:00 = 11:20:00 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[picasso]

Try this
Code:
mysql> select addtime('10:00:00', sec_to_time(80*60)) from dual;
+-----------------------------------------+
| addtime('10:00:00', sec_to_time(80*60)) |
+-----------------------------------------+
| 11:20:00 |
+-----------------------------------------+
1 row in set (0.00 sec) -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --