Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- purchased >= date_sub(now() ,interval 7 day)
- SELECT * FROM table WHERE YEARWEEK(purchased) = YEARWEEK(NOW());
- $sunday = date(('Y-m-d H:i:s'), strtotime('last sunday 00:00'));
- $sql = "SELECT * FROM table WHERE purchased >= '$sunday'";
Add Comment
Please, Sign In to add comment