WEEK

Returns the week number for a given date.

Syntax

WEEK(date);

Example

SELECT WEEK('2020-06-20');