Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Extracts the “week number” from the given datetime. There are eight ways to number weeks, described below.
WEEK ( dateobj, [mode] )
WEEKOFYEAR ( dateobj )
Mode | Description | Counting from |
---|---|---|
0 | Week (0 to 53) starting Sunday | First week with a Sunday |
1 | Week (0 to 53) starting Monday | First week with 4+ days |
2 | Week (1 to 53) starting Sunday | First week with a Sunday |
3 | Week (1 to 53) starting Monday | First week with 4+ days |
4 | Week (0 to 53) starting Sunday | First week with 4+ days |
5 | Week (0 to 53) starting Monday | First week with a Monday |
6 | Week (1 to 53) starting Sunday | First week with 4+ days |
7 | Week (1 to 53) starting Monday | First week with a Monday |
WEEKOFYEAR (date)
is equivalent to WEEK(date, 3)
.
Integer
select week('2009-02-13 23:31:30', 7);
+--------------------------------+
| week('2009-02-13 23:31:30', 7) |
+--------------------------------+
| 6 |
+--------------------------------+
Related Topics