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