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 |
+-----------------------------------------+--------------------------------------------------+