Selecting between two dates within a DateTime field - SQL Server

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

Answers


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.


Need Your Help

C# String ASCII representation

c# regex string ascii

How can I insert ASCII special characters (e.g. with the ASCII value 0x01) into a string?