ICEBERG_MONTH

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

Syntax

ICEBERG_MONTH(<value>)

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

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

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

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

SELECT iceberg_month('2025-12-15'::DATE) AS month_partition;

Returns:

month_partition
671

⌘I