How do I get Timestamp minus 6 weeks in MySQL?

I find this syntax more readable than date_sub, but either way works.

WHERE timestamp >= NOW() - INTERVAL 6 WEEK

If you want to go by “Today” (midnight) instead “now” (current time), you would use this

WHERE timestamp >= DATE(NOW()) - INTERVAL 6 WEEK