datetime 0.33 ms rounded problem

• Chan Wai Yin

  SSCommitted

  Points: 1883

  More actions

  October 13, 2009 at 8:58 pm

  #139537

  Hi,

  According to BOL the datetime field would round to 0.33 ms, but we want to store exact and accurate millisecond using datetime field such that 0.001 s and 0.002 s would not round to 0.000 s, as this rounding would cause us trouble and inconvenince for datetime comparison and calculation when communicating with other programming language(e.g. C++/Java/.Net). Is there any other alternative to solve such kind of problem? Thanks a lot.

  Best regards,

  Wallace

• diamondgm

  SSCrazy

  Points: 2824

  More actions

  October 14, 2009 at 1:49 am

  #1065520

  Hi Wallace,

  I can't find where BOL says that it will round to 0.33ms, but if I understand your situation correctly, 0.33ms rounding is no problem for you.

  You want accuracy within 0.001 seconds, what I presume happens is that 0.00133sec ROUNDS to 0.001s and that 0.00177s would ROUND to 0.002s.

  This gives you an accuracy of 1ms or 0.001s

  Remember that 0.33 ms = 0.00033 s: http://www.google.com/search?q=0.33+ms+in+seconds&btnG=Search

  Hope I understood you.