Query Run
SELECT DATE_FORMAT(CURRENT_DATE, '%Y%m%d000000') 7 years ago
SELECT convert(varchar, getdate(), 112) 7 years ago