11.4.16 WEEKOFYEAR(date)函数
WEEKOFYEAR(date)函数返回日期位于一年中的第几周。使用示例如下:
mysql> SELECT WEEKOFYEAR(NOW());
+-------------------+
| WEEKOFYEAR(NOW()) |
+-------------------+
| 50 |
+-------------------+
1 row in set (0.00 sec)
WEEKOFYEAR(date)函数返回日期位于一年中的第几周。使用示例如下:
mysql> SELECT WEEKOFYEAR(NOW());
+-------------------+
| WEEKOFYEAR(NOW()) |
+-------------------+
| 50 |
+-------------------+
1 row in set (0.00 sec)