RE: [PHP-DB] Adding times in php

I would consider adding either: 1. a virtual column in the sql to add up the times 2. issue another sql statement to get a total 3. store a total in a cookie / session initially bastien

From: "Allan" <allan@binaryone.com.au> Reply-To: "Allan" <allan@binaryone.com.au> To: php-db@lists.php.net Subject: [PHP-DB] Adding times in php Date: Sat, 4 Mar 2006 15:13:13 +0800 Hi All I have two tables with columns of times that it took to perform tasks eg: 8:40 6:50 8:30 10:55 --------- 34:55 total time taken to complete the tasks in hours and minutes I am able to add the times with sql however I need to add the totals to cone up with a grand total and because of the makeup of the tables I cant use sql. I am there for going to have to use php code and this is where the problem comes in because in sql there is SEC_TO_TIME and TIME_TO_SEC functions that allow easy addition of the times but I cant find an equivalent in php. Does any one know of a way that I can add to times together in php. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php