Well I am trying to figure out how long it should take to do something. So say the instructor says I am giving you 5 minutes to find each hidden item and there are three hidden items. Well then the person has 15 minutes to find all three.
In this case, I would not use the time data type. Plus, if you do and the total time reaches 24 hours or more, the time data type will fail there as well. Find a common base unit, use it and the integer data type.
That's basically what I'm going to do. Just keep them as int in SQL and let .NET timespan do the heavy lifting.....I just thought Msoft...you know the guys who gave us TimeSpan might have thought to add this capability to MSSQL??
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply