大数据学习之路

SQL : weekofyear

一天在一年中的第几个星期？

mysql> select current_date();
+----------------+
| current_date() |
+----------------+
| 2020-04-05     |
+----------------+

mysql> select weekofyear(current_date());
+----------------------------+
| weekofyear(current_date()) |
+----------------------------+
|                         14 |
+----------------------------+
1
2
3
4
5
6
7
8
9
10
11
12
13

reference