---
schema_version: "1"
id: 8319614a6e65d11a84acba190314267cd69e298547a627a361bfbbd9ccabf092
title: Day of Week
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-dow.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-dow.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 5795d1e2325f84417c7fcb580d39bc85179d8338a9060a68396b1c9bf75c671d
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# Day of Week

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

## Example

```nolang
SELECT OrderDate as "date", EXTRACT (DOW FROM OrderDate) as "day_of_week" FROM "dates_sample_data";
```

| date                | day_of_week |
| ------------------- | ----------- |
| 2015-01-21 15:30:00 | 3           |
| 2015-01-21 00:00:00 | 3           |
| 2015-01-31 10:00:30 | 6           |
| 2015-02-03 15:30:00 | 2           |
| 2016-01-21 23:59:59 | 4           |
| 2015-10-31 23:59:59 | 6           |
| 2015-12-03 00:00:00 | 4           |
| 2016-01-11 03:30:00 | 1           |
| 2016-01-11 03:30:00 | 1           |