CODEWITHSUNDEEP
sqlsql-serversql-server-2008sql-server-2005
Baz
Baz

Reputation: 13135

List rows after specific date

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?

Upvotes: 97

Views: 345341

Answers (2)

Ken Brummage
Ken Brummage

Reputation: 11

Let's say you want to get all records from a table called Table_One with a datetime column called date_value that have happened in the past six months...

CREATE TABLE (
  date_value DATETIME
) 

SELCECT *
FROM Table_One
WHERE date_value > DATEADD(month, -6, getdate());

This gives a bit more dynamic of a solution.

Upvotes: 1

cgatian
cgatian

Reputation: 22994

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

Upvotes: 150

Related Questions