> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Month

> Use the Sigma Month function to return an integer representing the month component of a specified date and time.

The **Month** function returns an integer representing the month component of a specified date and time.

## Syntax

```
Month(date, [timezone])
```

The Month function has the following arguments:

<dl>
  <dt>
    date
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    The date or the column that contains date values where Sigma extracts the month component
  </dd>

  <dt>
    timezone
  </dt>

  <dd>
    Optional
  </dd>

  <dd>
    The 

    <a href="https://en.wikipedia.org/wiki/List_of_tz_database_time_zones" data-rt-link-type="external">IANA time zone</a>

    ; for example, (e.g., 

    <code>“America/Los_Angeles”</code>

    , used to convert the date value before extracting the month component.
  </dd>

  <dd>
    When omitted, 

    <strong>timezone</strong>

     Sigma evaluates the date in UTC time.
  </dd>
</dl>

## Examples

```
Month(Date("2007-08-14"))
```

Extracts the month component from the specified date (August 14, 2007) and returns `8` to represent the eighth month of the year.

```
Month([Date])
```

The **Month** function returns the following values for the **Date** column:

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/a5bdcbd9ce489cbd38231048587994d3381fae26635f9dc588bb9fe91e2ce206/assets/docs-images/535a2fe-function-month-example.png)

## Related resources

* [MonthName](/docs/monthname)
* [DatePart](/docs/datepart)
* [Second](/docs/second)
* [Minute](/docs/minute)
* [Quarter](/docs/quarter)
* [Year](/docs/year)
* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Quickstart: Common date functions and use cases
  </a>