Quick Ref.

SELECT
GROUP BY

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

MONTH

MONTH allows you to retrieve the month from a date.

 MONTH(d)

In this example you get the month from the date field whn.

Results

See also: