Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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

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>