Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DaleA
Starting Member
1 Post |
 Posted - 2009-10-14 : 06:00:34
|
| HiThis may well be a stupid question but I haven't been able to find an answer to this anywhere.I'm new to SQL and as a test database I thought I'd create a database containing triathlon race results. In this database I have a table containing race results, so this contains results columns for Swim, Bike, Run and overall finish times. All of these columns are setup with Data Type - Time(7) - so for example the 1st overall finish time in my table is 00:55:42 - the problem I have is when trying to pull reports out of my table using SSRS instead of showing my times as a length of time taken 00:55:42 it's changing it to the time of day - 12:55 AM. Would anyone be able to tell me where I am going wrong with this - Have I used the wrong column type? or is there some way of telling SSRS not to change the times to time of day?I am using a trial copy of SQL Server 2008, and I used Report Builder 2.0 to create the reportI do apologies if any necessary information is missing from the above. I'm not sure how much information is required, if you need to know anymore just let me know and I'll post.Thanks |
|
|
winterh
Posting Yak Master
127 Posts |
Posted - 2009-10-14 : 07:31:48
|
| It is easy if you record startTime and finishTime.Then you can just use- SELECT DateDiff(mi, startTime, finishTime)But I do not know about your current query, I have actually never dealt with times before. LOL.[/fail at query] |
 |
|
|
|
|
|
Recording Time Results in SQL