Топ-100
 
CerebroSQL

DAYOFWEEK

Database: MySQL
Topic

Syntax:
DAYOFWEEK(date)

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

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

Example

mysql> SELECT DAYOFWEEK('2007-02-03');
-> 7