How do I get Timestamp minus 6 weeks in MySQL?

Question

I have a field named timestamp. This is the last time a member was logged in. I am looking to include a where clause in a query for something like

WHERE timestamp > todays date - 6 weeks

How would I do this? I am trying to only include users that have logged in in the last 6 weeks.

Thanks

Answer 1

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 

Answer 2

where column>=date_sub(now(), interval 6 week) 

Answer 3

This link demonstrates how you might acquire a timestamp of yesterday using the format DATE_ADD(CURDATE(), INTERVAL -1 DAY), therefore your query would probably be:

WHERE timestamp > DATE_ADD(CURDATE(), INTERVAL -42 DAY)

Answer 4

You can use between and now():

select somevalue 
from yourtable
where yourtimestamp between now() - interval 1 day and now()