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