Quick Ref.

SELECT
GROUP BY

Compatibility
QUARTER(d)
Engine	OK	Alternative
ingres	yes	EXTRACT(QUARTER FROM d)
mysql	yes	EXTRACT(QUARTER FROM d)
oracle	no	TO_CHAR(d,'Q')
postgres	no	EXTRACT(QUARTER FROM (d)
sqlserver	no	DATEPART(QUARTER,d)

QUARTER

QUARTER allows you to retrieve the 3 month period from a date.

QUARTERS
First Quarter	1	January 1	March 31
Second Quarter	2	April 1	June 30
Third Quarter	3	July 1	September 30
Fourth Quarter	4	October 1	December 31

 QUARTER(d)

In this example you get the quarter from the date field wk. Lately, Cliff Richard favours Q4.

Results

See also: