Quote:
Originally Posted by Capt Jack
Is this a table you built?
|
Oh hell no! It's a commercial product from a company that ought to know better.
I found what I needed. After checking my math I figured out the values where 100's of a second not milliseconds. However SQL does not seem to have a centisecond option so I ended up converting to milliseconds anyways.
rtrim(substring(Convert(varchar,dateadd(ms,time*10 ,'2010-10-2'),13),13,5))
did the trick.