Time Only db field 1

[jgurgen]

im trying to create a database for my hockey league and i need to keep track of penalties. To do this i need a timeIn and timeOut but i wanna be able to track exact minutes in penatly box. I figure if i can just store time in a db field that would allow me to subtract the two to get the # of minutes and seconds one was in the penalty box.

How can i store just minutes and seconds in the database?

example:
timeIn - 5:35
timeOut - 4:15
Total Time - 1:20

 

[r937]

hmmm... the TIME datatype, perhaps?

the difference can then be obtained using the TIMEDIFF function

r937.com | rudy.ca

 

[jgurgen]

oh sorry not too familiar with mysql and didnt know there was a time datatype, thought there was only DateTime

 

[r937]

allow me to introduce you to the fine online manual --

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html

you will often get an answer faster there than you can here

not always, but often ;-)

r937.com | rudy.ca