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

 QUARTER(d)

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


Results
See also: