Which field does EXTRACT pull?

Question

Accepted Answer

EXTRACT(field FROM date) pulls out a single component of a date or timestamp. YEAR returns 2024, MONTH would return 7, DAY would return 15. QUARTER would return 3 (July is in Q3) - a common confusion when the field name is easy to mix up. PostgreSQL also supports DATE_PART('year', date) which works identically. Common fields: YEAR, MONTH, DAY, QUARTER, HOUR, MINUTE, SECOND, DOW (day of week, 0=Sunday), DOY (day of year).