> 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

```sigma
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 

    [IANA time zone](https://en.wikipedia.org/wiki/List_of_tz_database_time_zones)

    ; for example, (e.g., 

    `“America/Los_Angeles”`

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

  <dd>
    When omitted, 

    **timezone**

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

## Examples

```sigma
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.

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

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

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/a5bdcbd9ce489cbd38231048587994d3381fae26635f9dc588bb9fe91e2ce206/assets/docs-images/535a2fe-function-month-example.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20261007%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20261007T063624Z&X-Amz-Expires=604800&X-Amz-Signature=b2490ae65c68a5ff6bd226cd910f2de1e985479ce78552ee9883464796bdfa02&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Related resources

* [MonthName](/docs/monthname)
* [DatePart](/docs/datepart)
* [Second](/docs/second)
* [Minute](/docs/minute)
* [Quarter](/docs/quarter)
* [Year](/docs/year)
* [Quickstart: Common date functions and use cases](https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html)