How to select records between a date to another date given a DateTime field in a table.
This question is related to
sql
sql-server-2005
datetime
SELECT *
FROM tbl
WHERE myDate BETWEEN #date one# AND #date two#;
select *
from blah
where DatetimeField between '22/02/2009 09:00:00.000' and '23/05/2009 10:30:00.000'
Depending on the country setting for the login, the month/day may need to be swapped around.
Source: Stackoverflow.com