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

# Day

> Returns the day of the month of a date value as a number.

Returns the day of the month of a date value as a number.

## Usage

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

**date** (required) The date from which to extract the day component.

**timezone** (optional) Name of [IANA time zone](https://en.wikipedia.org/wiki/List_of_tz_database_time_zones) to get the date part at (*e.g.,* “America/Los\_Angeles”). When calculating a time zone, input dates are treated as UTC.

## Example

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

* Returns 14.

```
Day([Date])
```

* Returns the day of the month of each date value in the `[Date]` column as a number.

## Related resources

* [DatePart](/docs/datepart)
* <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>