QUARTER()

QUARTER() — Returns the quarter of the year as an integer value

Synopsis

QUARTER( timestamp-or-date )

Description

The QUARTER() function returns an integer value between 1 and 4 representing the quarter of the year in a DATE or TIMESTAMP value. The QUARTER() function produces the same result as using the QUARTER keyword with the EXTRACT() function.

Examples

The following example uses the QUARTER() and YEAR() functions to group and sort records containing a timestamp.

SELECT year(starttime), quarter(starttime), 
    count(*) as eventsperquarter
    FROM event
    GROUP BY year(starttime), quarter(starttime) 
    ORDER BY year(starttime), quarter(starttime);