select from_unixtime(nome_campo,"%Y") as anno
from tabella