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