Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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

The mode could be 0 ,1 ,2 ,3 ,4 ,5 ,6 ,7. mysql> mysql> SELECT YEARWEEK('1987-01-01'); +------------------------+ | YEARWEEK('1987-01-01') | +------------------------+ |                 198652 | +------------------------+ 1 row in set (0.00 sec) mysql>