Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dwayne Dibley Use of DATETIME and BETWEEN - Part 2 RE: Use of DATETIME and BETWEEN - Part 2

  • November 18, 2011 at 3:47 am

    #1409777

    cengland0 (11/18/2011)

    Okay, so I knew it rounds the milliseconds to .000, .003, or .007; however, I didn't know when it rounds up or down.

    So, when the time ends in .001, what does it round to?

    same question for .002 and .999 because those are the ones in the QOTD that messed me up.

    .001 --> .000

    .002 --> .003

    .999 --> .000 (this has the possibility to "jump" to the next day)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP