List rows after specific date

Question

I have a column in my database called "dob" of type datetime. How do I select all the rows after a specific DoB in SQL Server 2005?

Answer 1

Simply put:

SELECT *  FROM TABLE_NAME WHERE dob > '1/21/2012' 

Where 1/21/2012 is the date and you want all data, including that date.

SELECT *  FROM TABLE_NAME WHERE dob BETWEEN '1/21/2012' AND '2/22/2012' 

Use a between if you're selecting time between two dates