MySQL Tutorial/Date Time Functions/YEARWEEK

SELECT MID(YEARWEEK("2000-01-01"),5,2);

   <source lang="sql">

mysql> mysql> SELECT MID(YEARWEEK("2000-01-01"),5,2); +---------------------------------+ | MID(YEARWEEK("2000-01-01"),5,2) | +---------------------------------+ | 52 | +---------------------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT YEARWEEK("2000-01-01");

   <source lang="sql">

mysql> mysql> SELECT YEARWEEK("2000-01-01"); +------------------------+ | YEARWEEK("2000-01-01") | +------------------------+ | 199952 | +------------------------+ 1 row in set (0.00 sec) mysql></source>

YEARWEEK(date), YEARWEEK(date,mode) returns year and week for a date.

The mode could be 0 ,1 ,2 ,3 ,4 ,5 ,6 ,7.

   <source lang="sql">

mysql> mysql> SELECT YEARWEEK("1987-01-01"); +------------------------+ | YEARWEEK("1987-01-01") | +------------------------+ | 198652 | +------------------------+ 1 row in set (0.00 sec) mysql></source>