• Testing the precision of GETDATE()...

    instead of getting values 595 and 15.6521,

    i got

    4262 -out of 10 million calls i got distinct 4262 values returned by GETDATE()

    and

    3.33318 - what is the precision of the GETDATE() function

    which is supposed to be true.

    i ran the given query in the post, which the answer is supposed to be true.

    i ran the query against SQL SERVER 2008

    if i am wrong somewhere, let me know