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@xxxxxxxxxxxxxxxx>
Reply-To: "Allan" <allan@xxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
