| Query | Run |
|---|---|
| select date_sub(now(), interval 7 day) + 0 | 1 year ago |
| select date_sub(now(), interval 7 day) | 1 year ago |
| select now() - (60 * 60 * 24 * 7) | 1 year ago |
| select now() + 0 #- (60 * 60 * 24 * 7) | 1 year ago |
| select now() #- (60 * 60 * 24 * 7) | 1 year ago |
| select now() - (60 * 60 * 24 * 7) | 1 year ago |
| select now() - 60 * 60 * 24 * 7 | 1 year ago |