query calculation

[leena]

Hi everyone,

I have 2 fields I am getting in a query:
startTime (is in time format 00:00:00)
gameLength (is in minutes)

What I want to do is have a query that will add the minutes for the gameLength to the startTime to give me the endTime.

I don't know how to do this. I figure it might be something like:
SELECT gameLocation, MINUTE($startTime + $gameLength) as endTime
FROM Game
WHERE Gameid=$game

I am not sure if this is right, but I want it (endTime) to end up being in time format (00:00:00), not in minute format. Can I do all that through my query?

Can someone help point me in the right direction?
Any help is greatly appreciated.
Thanks for your time!!

[sweetkisses_net]

Use UNIX timestamp instead 00:00:00 lol 🙂

[leena]

was that a dumb question?

Sorry I don't know the difference between my time 00:00:00, and your Unix time stamp.

Anyways our database has the time formatted this way 00:00:00 (11:10:12)

So are you saying that the query I had looked alright, but to use a unix time stamp? What is suppose to be unix time stamp? the startTime or the gameLength?

Thanks for your time.

[wandering_cloud]

Are you a PHP programmer. If you are, go to php documentation and search for mktime(), PHP has function to transfer time/date type to timestamp(integer), then you can do calculation. I don't know whether you can handle this in a query.

[sweetkisses_net]

Timestamp is number of seconds from 1970 year to today... you can easily add GameLength (in seconds) to startTime ... tak a look at manual page http://www.php.net/date & http://www.php.net/time

🙂

p.s. for timestamp in mysql use int field type

[leena]

Thanks for your help everyone. I got it!