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

WEEKDAY(): Day number of the weekday 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.

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

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;

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com