Example
SELECT DAYOFWEEK("2017-06-15");Definition and Usage
The DAYOFWEEK() function returns the weekday index for a given date (a number from 1 to 7).
Note
1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday.
Syntax
DAYOFWEEK(
date
)Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The date to return the weekday index from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|