SQL query for today’s date minus two months

I want to select all the records in a table where their date of entry is older then 2 months.

Any idea how I can do that?

I haven’t tried anything yet but I am on this point:

SELECT COUNT(1) FROM FB WHERE Dte > GETDATE()

​x
 
SELECT COUNT(1) FROM FB WHERE Dte > GETDATE()​

Answer

If you are using SQL Server try this:

SELECT * FROM MyTable
WHERE MyDate < DATEADD(month, -2, GETDATE())

 
SELECT * FROM MyTableWHERE MyDate < DATEADD(month, -2, GETDATE())​

Based on your update it would be:

SELECT * FROM FB WHERE Dte <  DATEADD(month, -2, GETDATE())

 
SELECT * FROM FB WHERE Dte <  DATEADD(month, -2, GETDATE())​