suicide1405241470 0 Report post Posted September 10, 2004 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! Share this post Link to post Share on other sites
Hercco 0 Report post Posted September 13, 2004 I'm not familiar with SQL Server 2000, but I'd guess there is a simple datatype TIME? That should be exactly what you are looking for.One option would be to convert the time into seconds and store it as an integer. Share this post Link to post Share on other sites