Take the 2-minute tour ×

i am working on a app that is keeping track of high school sporting even scores.

it will allow users to submit scores of games in progress. right now i have a database table called scores.

But i am stuck when it comes to representing the amount of time in minutes and seconds left in the game.

share|improve this question
Instead of recording the (relative) "time left" consider reporting the "time submitted" as well as the "end time". Then the "time left" is just the difference of the other two (absolute) times. –  user166390 Jul 19 '12 at 3:37
i am capturing the timestamp of when the score was submitted by the user. although there is really no way of capturing the end time since its "game time" and you have stoppages of play or the stoppages of the game clock due to timeouts, an incomplete pass, or the ball carrier going out of bounds. –  Eric Cumbee Jul 19 '12 at 3:42
add comment

1 Answer

up vote 2 down vote accepted

You can use the TIME type:


share|improve this answer
that seemed like the obvious answer, but i was not sure since i was not representing a time of day, but an elapsed or remaining time. thank you. –  Eric Cumbee Jul 19 '12 at 3:36
add comment

Your Answer


