Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT YEARWEEK(2000-01-01)

mysql> mysql> SELECT YEARWEEK('2000-01-01'); +------------------------+ | YEARWEEK('2000-01-01') | +------------------------+ |                 199952 | +------------------------+ 1 row in set (0.00 sec) mysql>