SQL Function Reference

QUARTER

Returns the quarter of the year (1-4) for a given date.

MySQL

QUARTER(date)

date

The date or datetime value.

Examples

MySQL

SELECT QUARTER(date)
FROM Payments;

MySQL

SELECT member_name,
	QUARTER(birthday)
FROM FamilyMembers;