MySQL Tutorial/Date Time Functions/WEEKOFYEAR

WEEKOFYEAR(date) returns the calendar week of the date as a number in the range from 1 to 53.

   <source lang="sql">

mysql> mysql> SELECT WEEKOFYEAR("1998-02-20"); +--------------------------+ | WEEKOFYEAR("1998-02-20") | +--------------------------+ | 8 | +--------------------------+ 1 row in set (0.00 sec)</source>