WEEKDAY() MySQL function to return day number of the year from 0 to 6

SELECT WEEKDAY('2024-01-01'); # 0
SELECT WEEKDAY('2024-12-31'); # 1
SELECT WEEKDAY('2024-02-31'); # NULL

Syntax

WEEKDAY(date)

Example

SELECT WEEKDAY('2016-09-21')

Output is 2

WEEKDAY() function to get number from 0 to 6 based on Weekday in MySQL

Using CURDATE()

SELECT WEEKDAY(CURDATE())

This will return weekday in number of present ( today's ) date.

CURDATE()

For a invalid date we will get Null as output

SELECT WEEKDAY('2015-02-31')

Output is NULL
DEMO: Select date from Calendar to execute WEEKDAY()
Output of WEEKDAY() function is from 0 to 6,
0 for Monday, 1 for Tuesday .... 6 for Sunday

Yesterday today and tomorrow WEEKDAY()

This query will return WEEKDAY() number of yesterday , today and tomorrow

SELECT WEEKDAY(CURDATE()- INTERVAL 1 DAY) as yesterday,
WEEKDAY(CURDATE()) as today,
WEEKDAY(CURDATE()+ INTERVAL 1 DAY) as tomorrow;

SQL Date WEEK() : Week Number in Year( 0 to 53 ) DAYOFWEEK() : Weekday Number from 1 to 7
SQL txt file for WEEKDAY()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

WEEKDAY(): Day number of the weekday from 0 to 6

Using CURDATE()

Yesterday today and tomorrow WEEKDAY()

Subhendu Mohapatra