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 s