Query Run
SELECT replace(current_date-7, '-', '') 4 years ago
SELECT replace(current_date, '-', '') 4 years ago
SELECT current_date 4 years ago
SELECT 1 4 years ago