
August 29th, 2004, 08:29 AM
|
|
Contributing User
|
|
Join Date: Jul 2003
Posts: 65
Time spent in forums: 34 m 56 sec
Reputation Power: 6
|
|
|
Times in Sql Server
I want to enter times for running event performances (like 10:26.35 for a person's 2-mile time, for instance). I am using sql server 2000. This is an ongoing concern for me since I do a lot of work with running events. Can someone give me some direction as to how I can best deal with this?
The datetime data types do a lot of converting to 'time-of-day' and that is not what I want. For instance, if I enter a 2-mile time of 10:26.35 (a pretty typical 2-mile time) my db converts it to 10:26:35 AM.
If I use varchar data type there is a ton of code to write when I want to sort the data.
Thanks!
|