Time in SQL

[Anon]

Hi,

Sorry for my english, I'm French

I have a field in a DB call 'temps' (type time) and all the value in this field are like 15:24:54 (hours:minutes:seconds)

I made a query with a SELECT like :
$req = mysql_query("SELECT DISTINCT candidates.equipe, classement.numero_equipe, SUM(classement.temps) as temps_sum FROM candidates, classement WHERE candidates.numero_equipe=classement.numero_equipe GROUP BY candidates.equipe, classement.numero_equipe ORDER BY temps_sum ASC LIMIT $debut,$nb");

I would like that the sum of my field 'temps_sum' in this SELECT return a result like : 12:10:03 + 05:55:10 = 18:05:13

Right now, the result looks like 675854

How can I have a result (the sum of my field in the query SELECT) like 18:05:13 ???

Thanks for your help...

[[deleted]]

You can't add times like that. the TIME type gives a 'time of day', and you can't add 23:00:00 and 23:00:00, because that would give a time somewhere in the next day.

Instead, you can use 'time_to_sec()' in sql to calculate the number of seconds for each time. Then you can add the seconds together, and use PHP's 'mktime()' and 'strftime()' to print the seconds as a time.
You must make sure that you also account for days!

[Anon]

Thanks Vincent for your help...