> ## 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.

> Reference material for the TO_YYYYMM function

# TO_YYYYMM

Extracts the year and month from a `DATE`, `TIMESTAMP`, or `TIMESTAMPTZ` value and combines them into an integer beginning with the four-digit year followed by the two-digit month.
`TO_YYYYMM(<expression>)` is equivalent to `EXTRACT(YEAR FROM <expression>) * 100 + EXTRACT(MONTH FROM <expression>);`

## Syntax

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

## Parameters

| Parameter      | Description                                             | Supported input types              |
| :------------- | :------------------------------------------------------ | :--------------------------------- |
| `<expression>` | The expression from which the time units are extracted. | `DATE`, `TIMESTAMP`, `TIMESTAMPTZ` |

`TIMESTAMPTZ` values are converted to local time according to the session's `time_zone` setting before extracting the time units.

## Return Types

`INT`

## Remarks

The `TO_YYYYMM` function can be used in the `PARTITION BY` clause of `CREATE TABLE` commands.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CREATE TABLE test (
  t TIMESTAMP
)
PARTITION BY TO_YYYYMM(t);
```

## Example

<div className="query-window">
  ```
  SELECT TO_YYYYMM('2025-04-03') as yyyymm, TO_YYYYMMDD('2025-04-03') as yyyymmdd;
  ```

  | yyyymm <span>int</span> | yyyymmdd <span>int</span> |
  | :---------------------- | :------------------------ |
  | 202504                  | 20250403                  |

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

<div className="query-window">
  ```
  SELECT TO_YYYYMM('1920-12-30') as yyyymm, TO_YYYYMMDD('1920-12-30') as yyyymmdd;
  ```

  | yyyymm <span>int</span> | yyyymmdd <span>int</span> |
  | :---------------------- | :------------------------ |
  | 192012                  | 19201230                  |

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