My SQL captures the last active users in one week

Question

I have a request, and I'm not sure how to restrict users to the last login date. I only want to return the users who logged in last week. Here is my request:

"SELECT `ID` FROM `Profiles` WHERE `DateLastLogin` < '[1WEEK]'"

DateLastLogin is a datetime field.

Answer 1

WHERE DateLastLogin > ADDDATE(NOW(), INTERVAL -1 WEEK)

Answer 2

You can do it:

SELECT `ID` FROM `Profiles` WHERE `DateLastLogin` < DATE_SUB(NOW(), INTERVAL 7 DAY)

or

SELECT `ID` FROM `Profiles` WHERE `DateLastLogin` < DATE_SUB(NOW(), INTERVAL 1 WEEK)

Answer 3

"SELECT `ID` FROM `Profiles` WHERE `DateLastLogin` < DATE_SUB(curdate(), INTERVAL 1 WEEK)"

The request you are looking for is likely

"SELECT `ID` FROM `Profiles` WHERE `DateLastLogin` BETWEEN NOW() AND DATE_SUB(curdate(), INTERVAL 1 WEEK)"

Answer 4

In PHP you can use

strtotime('-1 week');

and this will output unix time from a week ago