To add two times which is hh:mm:ss fromat

[ditty]

Pls help me to add two times which is in mysql database table....Very urgent...Thank you

[dickersonka]

you can do it as select it from the mysql side

select time1, time2, addtime(time1,time2)
from table

[Shanti C]

You could use DATE_ADD/DATE_SUB such as ADDDATE/SUBDATE and SUBTIME, but that's only available since MySQL 4.1.1.

check this:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html