SQL Add Days to a Date

What & Why

date_column + n adds n days to a date. This is the pattern the Date Arithmetic lesson introduced, applied to a concrete, common use case: computing a follow-up date, a deadline, or an expiration.

See How It Works

SELECT
  id AS lead_id,
  created_at,
  created_at + INTERVAL '7 days' AS follow_up_at
FROM marketing.leads
ORDER BY lead_id;