What is the equivalent of 'yearweek' function in BigQuery standard SQL?

Question

I'll need to extract exactly the "yearweek" of different dates in my table but I couldn't find any match for 'yearweek' in BigQuery (Standard SQL / Legacy SQL ).

Thanks

Answer 1

For the result as a string, use '%Y%W' with "format". For example:

select format_date('%Y%W', current_date)