retrieving a part of current year in mysql

mysql, select, sql

Solution

try this one

SELECT DATE_FORMAT(datefield, '%y')

Problem

i want to retrieve the last two digits of current year for ex- i want to retrieve "13" from current year "2013'. help me provide a suitable query for this Thanx

Original source