Selecting between two dates within a DateTime field - SQL Server

Question

How to select records between a date to another date given a DateTime field in a table.

Answer 1

SELECT * 
FROM tbl 
WHERE myDate BETWEEN #date one# AND #date two#;