adding times / percentages etc.

phpjaco

Hello

I am trying to do the following add time fields from a db together so that I can work out the total number of hours.

The field in the db that I want to add is a TIME field, how do I add this together? When I add then tohether normally such as

  $total_time += $row['time'];

I get a integer, how do I solve this?

bogu

To get the number of hours u need to get the unix_timestamp of the beginning of the work and the end of the work witch is an integer (the number of seconds), in the end u make a function that calculates the number of hours.

phpjaco

hello, thanks for the reply. Im slightly confused I am trying to add times together in other words hh:mm:ss and also there is no beginning and no end I just want to add all the times together to get a total time?

are you not talking about timestamps, are timestamps and time the same thing?

Installer

If you want to add TIME values, one from each row (as I think you want to do), this should work:

$query = "SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_field))) " .
         "AS sum_time FROM my_table";

To add values in each row:

$query = "SELECT ADDTIME(time_a, time_b) AS total_time FROM my_table";

I think, but I'm not sure, that you'll need at least MySQL v. 4.1 for these to work.

Edit: The MySQL data types TIMESTAMP and TIME aren't the same thing, and the Unix timestamp is something else again.

Data Types
Date and Time Functions