Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
EXTRACT(YEAR FROM d)
Engine OK Alternative
mysql yes YEAR(d)
oracle yes TO_CHAR(d,'YYYY')
postgres yes YEAR(d)
sqlserver no DATEPART(YEAR,d)

EXTRACT

EXTRACT allows you to retrieve components of a date.

You can extract also YEAR, MONTH, DAY, HOUR, MINUTE, SECOND. 

 EXTRACT(YEAR FROM d)    EXTRACT(MONTH FROM d)
 EXTRACT(DAY FROM d)     EXTRACT(HOUR FROM d)
 EXTRACT(MINUTE FROM d)  EXTRACT(SECOND FROM d)

In this example you get the year and the month from the date whn.


Results
See also: