ICEBERG_DAY

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

Syntax

ICEBERG_DAY(<value>)

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

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

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

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

SELECT iceberg_day('2025-12-15'::DATE) AS day_partition;

Returns:

day_partition
20437

⌘I