Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

WEEK(date), parameter, returns the week of the year in the range 0 to 53

mysql> mysql> SELECT WEEK('2001-12-26'); +--------------------+ | WEEK('2001-12-26') | +--------------------+ |                 51 | +--------------------+ 1 row in set (0.00 sec) mysql> Without a second parameter, WEEK(date) assumes that Sunday is the first day of the week at the beginning of the year any days before the 'first day' come in week 0. mysql> mysql> select WEEK('2000-01-01'); +--------------------+ | WEEK('2000-01-01') | +--------------------+ |                  0 | +--------------------+ 1 row in set (0.00 sec) mysql> You can add the firstday parameter. 0 representing Sunday, 1=Monday, and so on. mysql> mysql> select WEEK('2000-01-09'); +--------------------+ | WEEK('2000-01-09') | +--------------------+ |                  2 | +--------------------+ 1 row in set (0.00 sec) mysql> select WEEK('2000-01-09',1); --you told MySQL to start counting from the Monday +----------------------+ | WEEK('2000-01-09',1) | +----------------------+ |                    1 | +----------------------+ 1 row in set (0.00 sec)