Example
Return the quarter of the year for the date:
SELECT QUARTER("2017-06-15");
Definition and Usage
The QUARTER() function returns the quarter of the year for a given date value (a number from 1 to 4).
- January-March returns 1
- April-June returns 2
- July-Sep returns 3
- Oct-Dec returns 4
Syntax
QUARTER(date)