Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
MONTH(d)
Engine OK Alternative
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: