Get Rows from at least 3 days ago

Question

I have a table with column datetime and I need to get the results that already have 3 days of existence, all more than 3 days, I tried to use

SELECT *, DATE_FORMAT(date, '%m/%d/%Y') FROM tb WHERE DATE(date) = CURDATE() - INTERVAL 3 DAY ORDER BY ID DESC

But it did not give.

Answer 1

Your where must be:

WHERE DATE(date) < DATE_SUB(CURDATE(), INTERVAL 3 DAY)

I put in the Github for future reference.