DAYOFWEEK

Description

Returns the weekday index of the date, where Sunday is 1, Monday is 2, and Saturday is 7.

Syntax

DAYOFWEEK(<dt>)

Parameters

Parameter	Description
<dt>	The date expression to be calculated

Return Value

Returns the weekday index of the date.

Examples

select dayofweek('2019-06-25');

+----------------------------------+
| dayofweek('2019-06-25 00:00:00') |
+----------------------------------+
|                                3 |
+----------------------------------+
```text

```sql
select dayofweek(cast(20190625 as date)); 

+-----------------------------------+
| dayofweek(CAST(20190625 AS DATE)) |
+-----------------------------------+
|                                 3 |
+-----------------------------------+