Athletes Data Base

[pau75]

I'm developing a DB for a track & field coach so he can keep a record of all of his athletes. My question is, how can I save their times in order for a posterior work with them, as a chart o calculations. What type must be the field on the table?

Thanks

pau75

 

[GoDawgs]

I'd store the seconds as decimal points in this case since you'll probably be comparing these...you could have a form that lets you enter the time in minutes and seconds and then converts it into a decimal to be stored in the db (i.e. the user enters 4 minutes and 5 seconds and you store 4.083...not a tough setup). Maybe someone else has a better idea since I've never had a situation like this.

Kevin

 

[pau75]

Thank you, but I need to storage them as possible data as an hours, minutes, seconds and cents of a second.

Example: An athlete runs a race in 1 hour, 36 minutes, 26 seconds and 29 hundreths of second.

How can the user enter this kind of data?

Thank you again.

 

[lespaul]

just like kevin said. You have the input form set up to take hours, minutes, seconds and 1/100 of seconds, then calculate the total number of seconds.

So your example would be converted to:
(1 hour * 60 min/hr * 60 sec/min) +
(36 minutes * 60 sec/min) +
26 seconds = 5786

then the hundreths would be the decimal.

5786.29

- that's what you would store in your table.

When you need to display the hours/minutes/seconds, you would do the opposite.