MySQL DAYOFWEEK Function

MySQL DAYOFWEEK Function

 MySQL DAYOFWEEK Function



The DAYOFWEEK the function returns the weekday index for a date i.e., 1 for Sunday, 2 for Monday, … 7 for Saturday. These index values correspond to the ODBC standard.

The following illustrates the DAYOFWEEK function:

DAYOFWEEK(date)

The DAYOFWEEK the function accepts 1 argument which is a DATE or DATETIME value. It returns an integer that ranges from 1 to 7 that represents Sunday to Saturday.

The DAYOFWEEK function returns NULL if the date is NULL, zero ( 0000-00-00), or invalid.

The following example returns the weekday index of December 1st, 2010

mysql> SELECT DAYNAME('2012-12-01'), DAYOFWEEK('2012-12-01'); +-----------------------+-------------------------+ | DAYNAME('2012-12-01') | DAYOFWEEK('2012-12-01') | +-----------------------+-------------------------+ | Saturday | 7 | +-----------------------+-------------------------+ 1 row in set (0.00 sec)

In this query, the DAYNAME the function returns weekday’s name while DAYOFWEEK the function returns the weekday index of December 1st, 2011.

Reactions

Post a Comment

0 Comments

close