Syntax:
DAYOFWEEK(date)

Returns the weekday index for date (1 = Sunday, 2 = Monday, ..., 7 =
Saturday). These index values correspond to the ODBC standard. Returns
NULL if date is NULL.

URL: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

