SELECT current_date + (6 - EXTRACT(DOW FROM current_date)) * '1 day'::INTERVAL;