How do I select rows in my MySQL DB with a datetime of today - 2 days?

Question

I am trying to do this:

WHERE dateadded < TODAY - 2 days

What is the correct MySQL syntax for this?

score 0 · Answer 1 · answered Nov 06 '13 at 22:24

0

WHERE DATEDIFF(CURDATE(), dateadded) > 2

answered Nov 06 '13 at 22:24

Andrei Nicusan

1 Answers1