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