Mega Code Archive

 

Categories / MySQL / Date Time

 

Retrieve year from a date

SELECT YEAR(CURRENT_DATE);  /*mysql>  SELECT YEAR(CURRENT_DATE); +--------------------+ | YEAR(CURRENT_DATE) | +--------------------+ |               2005 | +--------------------+ 1 row in set (0.00 sec) */