Home Forums Article Discussions Article Discussions by Author Discuss content posted by jkelly DateTime Precision RE: DateTime Precision

  • November 28, 2011 at 2:30 am

    #1413286

    As several people have pointed out, this "explanation" is bogus.

    SQL Server is comparing these values as strings - this has nothing to do with datetime precision. Replace the '2011-07-31 00:00:00.000' with '2011-07-31 REDHERRING' and you get the same result.