DateTime comparisons in SQL Server 2007
Aug 28th, 2008 | By Christian Donner | Category: SQL ServerThe issue is that SQL Server’s DateTime data type appears to be able to resolve milliseconds – but it really does not. It rounds to the nearest 0, 3, or 7.
Consider the following:
