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

TO_CHAR (dates)

TO_CHAR allows you to convert a date to a string using a variety of formats. 

 TO_CHAR(d, 'YYYY') -> Four digit year
 TO_CHAR(d, 'MM')   -> Two digit month
 TO_CHAR(d, 'DD')   -> Two digit day
 TO_CHAR(d, 'HH24') -> Two digit hour
 TO_CHAR(d, 'MI')   -> Two digit minutes
 TO_CHAR(d, 'MON')  -> Three character month

In this example you get the month as a three character abbreviation and a four digit year from the date field whn.


Results
See also: