Listing 2: Queries That Highlight a Danger of 
Datetime Processing in SQL Server

INSERT INTO OrderDateTest VALUES(5, 500, '2003-03-30 23:59:59.999')
INSERT INTO OrderDateTest VALUES(6, 800, '2003-03-31 23:59:59.999')

SELECT *
FROM OrderDateTest
WHERE OrderDate >= '03/31/03' AND OrderDate < '04/01/03'

SELECT *
FROM OrderDateTest
WHERE OrderId IN (5,6)