> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Extract year as years from 1970 according to Iceberg partition transforms

# 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](https://iceberg.apache.org/spec/#partition-transforms).

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
ICEBERG_YEAR(<value>)
```

## Parameters

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

## Return type

`INTEGER`

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

## Remarks

The `ICEBERG_YEAR` function can be used in the `PARTITION BY` clause of [`CREATE ICEBERG TABLE`](/reference-sql/commands/data-definition/create-iceberg-table-as-select) commands.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CREATE ICEBERG TABLE events
  PARTITION BY (iceberg_year(event_date))
  AS SELECT * FROM source_events
WITH LOCATION = my_iceberg_location;
```

## Example

<div className="query-window">
  ```
  SELECT iceberg_year('2025-12-15'::DATE) AS year_partition;
  ```

  | year\_partition <span>int</span> |
  | :------------------------------- |
  | 55                               |

  <p><span>Rows: 1</span><span>Execution time: 6.03ms</span></p>
</div>