MySQL WEEKDAY()

MySQL 날짜함수, 시간함수

 

WEEKDAY()

   -

 

WEEKDAY([date])

의 형태

 

Returns the weekday index for date(0=Monday, 1=Tuesday, ... 6=Sunday)

 

mysql> SELECT WEEKDAY(NOW());
+----------------+
| WEEKDAY(NOW()) |
+----------------+
|              6 |
+----------------+
1 row in set (0.00 sec)

mysql> SELECT WEEKDAY('2020-04-16');
+-----------------------+
| WEEKDAY('2020-04-16') |
+-----------------------+
|                     3 |
+-----------------------+
1 row in set (0.00 sec)