可以使用 href =http://msdn.microsoft.com/en-us/library/ms187922.aspx =noreferrer> BETWEEN ：

SELECT * FROM table 
WHERE '2012-11-27' BETWEEN ArrivalDateTime AND DepartureDateTime