version 11
QUARTER (arithmetic_expression)
Description
The QUARTER function returns the quarter of the year (ranging from 1 to 4) in which the date passed in the arithmetic_expression occurs.
Example
Supposing that we have the PEOPLE table with a Date_of_Birth field. To find out the quarter of the date of birth for every person in PEOPLE:
SELECT QUARTER(Date_of_Birth) FROM PEOPLE;
See Also