---
schema_version: "1"
id: 2070e09542a42e5e969780d824e1ee29418bbb6cb313e05a92cab07d8875aa0b
title: Day of Month
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-date-day.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-day.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: f46c10c854940c3530ee44924c9c91327d24d76197f289bb007dc3c3b6eda6cb
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# Day of Month

Returns an integer that represents the day of the month for a specific date.

## Example

```nolang
SELECT OrderDate as "date", EXTRACT (DAY FROM OrderDate) as "day_of_month" FROM "dates_sample_data";
```

| date                | day_of_month |
| ------------------- | ------------ |
| 2015-01-21 15:30:00 | 21           |
| 2015-01-21 00:00:00 | 21           |
| 2015-01-31 10:00:30 | 31           |
| 2015-02-03 15:30:00 | 3            |
| 2016-01-21 23:59:59 | 21           |
| 2015-10-31 23:59:59 | 31           |
| 2015-12-03 00:00:00 | 3            |
| 2016-01-11 03:30:00 | 11           |
| 2016-01-11 03:30:00 | 11           |