1 week ago

MySQL
SELECT NOW - INTERVAL 1 WEEK;