ICEBERG_YEAR

Extracts the year from a date or timestamp value and returns it as the number of years since 1970, according to the Iceberg partition transforms specification.

Syntax

ICEBERG_YEAR(<value>)

Parameter	Description	Supported input types
`<value>`	The date or timestamp value to extract the year from.	`DATE`, `TIMESTAMP`, `TIMESTAMPTZ`

INTEGER Returns the number of years since 1970. For dates before 1970, returns a negative value.

The ICEBERG_YEAR function can be used in the PARTITION BY clause of CREATE ICEBERG TABLE commands.

CREATE ICEBERG TABLE events
  PARTITION BY (iceberg_year(event_date))
  AS SELECT * FROM source_events
WITH LOCATION = my_iceberg_location;

SELECT iceberg_year('2025-12-15'::DATE) AS year_partition;

Returns:

year_partition
55

⌘I