SQL Function Reference

WEEK

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

MySQL

WEEK(date[, mode])

date

The date or datetime value.

mode

Optional. The week mode (0-7).

Examples

MySQL

SELECT WEEK(date)
FROM Payments;

MySQL

SELECT member_name,
	WEEK(birthday)
FROM FamilyMembers;