PostgreSQL Query WHERE date is greater than 3 years old

Question

I have a table that contains 4 dates:

CREATE TABLE dates (
    date date
);

    11-mar-2008
    25-now-2007
    18-apr-2012
    20-apr-2012

I need a query that returns all dates that are older than three-years-old. That should be the first 2 dates.

This doesn't work for me:

SELECT * FROM dates WHERE date = now()::-1095;

Answer 1

SELECT 
  * 
FROM 
  dates 
WHERE 
  date < now() - '3 years' :: interval;

Also, naming your column date is not a good practice, as this is a reserved word in PostgreSQL.