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 |
|
sqlDan33
Starting Member
5 Posts |
 Posted - 2002-12-23 : 11:26:26
|
| How does one take in account of times with hundreth of seconds? Is it possible? What sort of field should be used to store this? Time fileds only go to hh:mm:ss... in text? Create an hour, minutes, second and hundreth of second fields? |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-12-23 : 11:52:18
|
| The datetime datatype is accurate to on three-hundredth of a second. Read more in Books Online.Jay White{0} |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-12-23 : 12:15:25
|
| Like Jay said, look at the DateTime Datatype and you'll also want to look at GetDate() which I usually use to fill the DateTime fields.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Hundreth of seconds