YEARWEEK() Function returns week and year in one string

Example

SELECT YEARWEEK( '1999-02-03' )

Returns

199905