SELECT WEEKDAY('1997-11-05'); : WEEKDAY « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. WEEKDAY
mysql>
mysql> SELECT WEEKDAY('1997-11-05');
+-----------------------+
| WEEKDAY('1997-11-05') |
+-----------------------+
|                     2 |
+-----------------------+
1 row in set (0.00 sec)

mysql>








14.56.WEEKDAY
14.56.1.WEEKDAY(date) returns the weekday index for date (0 = Monday, 1 = Tuesday, ... 6 = Sunday).
14.56.2.SELECT WEEKDAY('1997-11-05');
14.56.3.WEEKDAY(date) different and returns the weekday index for the given date(0=Monday, 1=Tuesday, 2=Wednesday, and so on).