ICEBERG_MONTH

Extract month as months from 1970-01-01 according to Iceberg partition transforms

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>)

Parameters

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

Return type

INTEGER

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

Remarks

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;

Example

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

month_partition int
671

Rows: 1Execution time: 4.77ms