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 |
|
JDrown
Starting Member
10 Posts |
 Posted - 2005-09-12 : 14:23:43
|
| I need to store time values in a table. Not as in "5:30 PM" but rather times for individuals running a race. What data type supports times of "1 hour, 32 minutes 48.22 seconds"....as in 01:32:48.29?The DateTime format simply does not seem to support the storage of a value like 01:32:48.29. What SQL Server data type would support that type of value?Thanks to all who reply!!! |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-09-12 : 14:47:31
|
| SQL stores the time down to milliseconds. How you DISPLAY the time is another question. Go to BooksOnline and then go to CAST & CONVERT and you'll see different formatting you can use to display datas & times in different ways. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-12 : 14:53:31
|
| We store these type of values as integer. Data is stored as number of seconds and then we format the duration at the presenation layer as needed.Tara |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-09-12 : 15:08:28
|
| oops ... I think I mis-read the original post. |
|
|
|
|
|
|
Data Type Question