SQL Server receipt date field if less than 3 months

Question

I just need the where clause in my select statement, where AddDate is less than or within a 3 month set. how

Select * FROM My Table where AddedDate DateDiff of DateNow less than 3 months 

Answer 1

Use DATEADD () :

 Select * FROM My Table where AddedDate>=DATEADD(m, -3, GETDATE()) 

Answer 2

 SELECT * FROM MyTable WHERE AddedDate >= DATEADD(month, -3, getdate()) 

Answer 3

not quite sure what I understand, but I think you need this feature

 where AddedDate >= dateadd(mm, -3, getdate())