adding total time in a column.

[naveendk.55]

I have a column with time in HH:MM:SS format.  How to add the total time in this column?

 

I tried the below steps but o/p display only 1..

 

$qry = "select SEC_TO_TIME(SUM(TIME_TO_SEC(time_utilization))) from tracker"; 
$result=mysql_query($qry) or die (mysql_error());
$row = mysql_num_rows($result); 



echo $row;  

[joel24]

try this from http://forums.mysql.com/read.php?20,194872,194872

SELECT SEC_TO_TIME(SUM(SECOND(time_utilization))) FROM tracker; 

[naveendk.55]

tried that and getting the error

 

:Notice: Undefined index: time_utilization in C:\wamp\www\strategyone\testing.php on line 28"

[ignace]

That's a PHP error not MySQL. Post your code.

[naveendk.55]

Below is the my code. If the error is resolved, then I'll put the code in the program to get full result. If it display the total, then I'll be able to resolve it. Below is the full code in my page except database connection include file.

 

 

$qry = "SELECT SEC_TO_TIME(SUM(SECOND(time_utilization))) FROM tracker";

$result=mysql_query($qry) or die (mysql_error());

$row = mysql_fetch_array($result);

 

 

echo $row; 

 

[fenway]

Of course it only displays "1" -- that's boolean truth.

 

You need to get the value for that expression -- with mysql_result() or by giving it an alias and using fetch_assoc().

[The Little Guy]

This works for me (result is in seconds):

 

select sum((hour(the_time) * 60 * 60) + (minute(the_time) * 60) + (second(the_time))) as seconds from test;

[The Little Guy]

I widthdraw my previous post with a quicker way:

 

select sec_to_time(sum(time_to_sec(the_time))) as total_time from test;

 

this will return something like:

120:20:13

 

if you want seconds, remove the sec_to_time function.

[naveendk.55]

Thanks Little Guy. That helped me and thanks again.