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#

Answer 2

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. Is this what you needed?