Entry

select FROM_UNIXTIME(now(),'%Y') gives me..2000 . this is stupid or am i stupid ?

Dec 3rd, 2001 08:05
ditoiu cristian,

yes , i'm stupid..
should do 
select date_fromat(field,'%Y') not FROM_UNIXTIME