MySQL WEEKOFYEAR()

MySQL 날짜함수, 시간함수

 

WEEKOFYEAR()

   -

 

WEEKOFYEAR(date)

의 형태

 

Returns the calendar week of the date as a number in the range from 1 to 53. WEEKOFYEAR() is a compatibility function that is equivalent to WEEK(date, 3).

 

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

mysql> SELECT WEEKOFYEAR('2020-04-05');
+--------------------------+
| WEEKOFYEAR('2020-04-05') |
+--------------------------+
|                       14 |
+--------------------------+
1 row in set (0.00 sec)