You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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
Info

WEEKOFYEAR (date) is equivalent to WEEK(date, 3).

Return Type

Integer

Examples

memsql> select week('2009-02-13 23:31:30', 7);
+--------------------------------+
| week('2009-02-13 23:31:30', 7) |
+--------------------------------+
|                              6 |
+--------------------------------+

Related Topics