Thu 28 Aug 2008
Why not to use BETWEEN for DateTime comparisons in SQL Server 2007
Posted by Christian Donner under MiscellaneousNo Comments
The issue with BETWEEN is that it does not behave consistenly. Sometimes it is inclusive of the 2nd DateTime value, sometimes it is not.
Consider the following:
Click to continue reading “Why not to use BETWEEN for DateTime comparisons in SQL Server 2007″
