WEEK
On this page
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
Last modified: May 31, 2023