Example
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
)Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The date or datetime to extract the quarter from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|