WEEK — MySQL Function Reference

WEEK

Returns the week number for a given date. The mode argument controls the week numbering system.

MySQL 8.1

WEEK(date[, mode])

date

The date or datetime value.

mode

Optional. The week mode (0-7).

Examples

MySQL 8.1

SELECT WEEK(date)
FROM Payments;

MySQL 8.1

SELECT member_name,
	WEEK(birthday)
FROM FamilyMembers;