QUARTER
Description
The function returns the quarter (1 to 4) of the given date. Each quarter includes three months:
- Q1: January to March
- Q2: April to June
- Q3: July to September
- Q4: October to December
Syntax
QUARTER(<datetime>)Parameters
| Parameter | Description |
|---|---|
<datetime> | A valid DATE or DATETIME value to determine the quarter. |
Return Value
- Returns an integer representing the quarter of the input date, ranging from 1 to 4.
- If the input is NULL, the function returns NULL.
- If the input is an invalid date (e.g., 0000-00-00), the function returns NULL.
Example
SELECT QUARTER('2025-01-16'),QUARTER('2025-01-16 01:11:10');+-----------------------------------------+--------------------------------------------------+
| quarter(cast('2025-01-16' as DATETIME)) | quarter(cast('2025-01-16 01:11:10' as DATETIME)) |
+-----------------------------------------+--------------------------------------------------+
| 1 | 1 |
+-----------------------------------------+--------------------------------------------------+