Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

WEEKDAY(date) returns the weekday index for date (0 = Monday, 1 = Tuesday, 6 = Sunday)

mysql> mysql> SELECT WEEKDAY('1998-02-03 22:23:00'); +--------------------------------+ | WEEKDAY('1998-02-03 22:23:00') | +--------------------------------+ |                              1 | +--------------------------------+ 1 row in set (0.00 sec) mysql>