PostgreSQL Function Reference

EXTRACT

Extracts a subfield from a date/time value (similar to DATE_PART).

PostgreSQL 17.5

EXTRACT(field FROM source)

field

The field to extract.

FROM source

The date/time value.

Examples

PostgreSQL 17.5

SELECT EXTRACT(
		YEAR
		FROM TIMESTAMP '2023-01-01'
	)