Sql Query for retrieving the Records which are 3 months old

Suthish
i tried to query your solution but the query was returning the Id which are older than 3 months.
I modified the query with changing the less than symbol to greater than symbol and it worked as  the Datecreated should be greater than the comparison Date


Correct me if am wrong.

I am still a beginner.

Thank You Guys for the Quick Responses.
What i need to do is delete the records in the database which are more than 3 months old .
So i tried few queries which i created but none of them worked for me.At  that point of time i was trying to write a query for retrieving the records from the database which are less than three months old .

And now i have the different ways of writing the same  query which really improves my knowledge base.

Thanks to you guys
You Rock............

why don't like this..

 SELECT Id FROM TABLE
 WHERE DateCreated is not null
 and DateCreated < DATEADD(month, -3, getdate())

 If want to remove time, refer following methods.

Actually, I'm wondering now whether that's what he really meant as his sample date is more than 4 months ago.

Anyway, doubtless he'll clarify that in due course.

shouldn't it be :

SELECT Id FROM TABLE WHERE DateCreated is not null and DATEDIFF(month, ISNULL(DateCreated, DATEADD(month, -3, GetDate())), GetDate()) > 2