SQL EXTRACT

What & Why

EXTRACT(field FROM source) pulls one specific component out of a date or timestamp value and returns it as a number. The next several lessons cover each individual field (year, quarter, month, week, day, day of week, hour) one at a time — this lesson is about the general syntax they all share.

See How It Works

SELECT
  id,
  created_at,
  EXTRACT(YEAR FROM created_at)::int AS signup_year,
  EXTRACT(MONTH FROM created_at)::int AS signup_month,
  EXTRACT(DAY FROM created_at)::int AS signup_day
FROM marketing.leads
ORDER BY created_at, id;