WEEK
Extracts the “week number” from the given datetime.
There are eight ways to number weeks, described below.
Syntax
WEEK ( dateobj, [mode] ) WEEKOFYEAR ( dateobj )
Arguments
dateobj: a valid date, datetime, or parsable date string.
mode: a number from 0 to 7, corresponding to the mode desired.
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 |
Important
WEEKOFYEAR (date) is equivalent to WEEK(date, 3).
Return Type
Integer
Examples
SELECT WEEK('2009-02-13 23:31:30', 7);
****
+--------------------------------+
| WEEK('2009-02-13 23:31:30', 7) |
+--------------------------------+
| 6 |
+--------------------------------+
Related Topics