MySQL determine human years from horse (Times 3)
===

I'm sorry, i have searched the threads and tried till my brain hurts but i have to ask for help.

I have a table called "Horse" with Id, Name, Born (Year only), Colour, Died.

I need to return the age of the horses that have died, and multiply by 3 to get the human years and display the horses ID, Name, and Human Years.

I am stuck at the very first hurdle. I cant get the table to return the Horses age.

I am using the suggestions of another SO user;

select DATEDIFF(horse.born, '2012') / 365.25 as Human Years

However this returns Null.

Also tried a CURDATE:

CURDATE('%Y%')-Born as Human Years
FROM horse;

No good. Any tips?
 