Day of Week

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

Example 

 
1SELECT OrderDate as "date", EXTRACT (DOW FROM OrderDate) as "day_of_week" FROM "dates_sample_data";
dateday_of_week
2015-01-21 15:30:003
2015-01-21 00:00:003
2015-01-31 10:00:306
2015-02-03 15:30:002
2016-01-21 23:59:594
2015-10-31 23:59:596
2015-12-03 00:00:004
2016-01-11 03:30:001
2016-01-11 03:30:001

Introducing SQL for CRM Analytics
Quick Start: Run Your First Query
SQL vs SAQL
SQL Statements
Date Functions
Access Parts of a Date
Project a Date Field
Filter By Date Parts or Date Field
Group By Date Part
Order By Date Part
Project a Custom Fiscal Date Part
Day in Week, Month, Quarter or Year Functions
Day of Week
Day of Month
Day of Quarter
Day of Year
First and Last Day in the Week, Month, Quarter or Year Functions
Aggregate Functions
Math Functions
String Functions and Operators
Release Notes
Previous Versions