time calculation

hozyali · April 4th, 2007, 08:23 AM

Hi,

I have a problem with a time calculation issue.

What I am trying to do is I have a mysql table with some specific times, like 8:00am, 8.30am etc etc.

Now I have another table which contains duration time for two specific places. like place1 & place2 = 45 minutes

Now I want to fetch the value of first table and minus the value of 2nd table. like 1st is 8.00am and 2nd is 45 minutes, so the result should be 7:45am

Can some one please let me know how can I do this with PHP?

Regards
Ali

www.starcomsystems.net
www.starcomhosting.net

Manu Sharma · April 6th, 2007, 10:11 AM

hi hozyali,

have u tried to use the mysql functions ADDDATE() and ADDTIME(). I believe they could come to your help,and it would be much easier and quick as compared to doing the same in php.

hozyali · April 9th, 2007, 08:02 AM

Quote:

quote:Originally posted by Manu Sharma
hi hozyali,

have u tried to use the mysql functions ADDDATE() and ADDTIME(). I believe they could come to your help,and it would be much easier and quick as compared to doing the same in php.

can you tell me how exactly to do that?

Ali

www.starcomsystems.net
www.starcomhosting.net
www.articlesbank.net
www.templatesbank.net