• jim.taylor (11/30/2009)


    ...if DateTime is only precise to 3.33 ms, why then is the answer just 1 ms off? Why not 3 ms?

    When the SELECT output's ms aspect can be one of 100 (from 99.9) or 103 (from 103.23), 100 is closer :-).

    I chose the wrong answer because I was thinking of roundoff in 3ms increments instead of in 3.33ms increments (although I should have realized that the choice should then have been between 99 and 102 :-)), so thank you to the questioner!