Show date difference in years

Hi.
I want to get the difference between two dates in years.
I have this:

SELECT DATEDIFF("2004-04-20","2010-05-7")

Code (SQL):

The result is shown in days. I need show this in years.
Exist another way?
Can some one help me?
Thanks.

 

Are you actually pulling these from a database?

 

I used this:

$diff = $datetime1->diff($datetime2);

Code (markup):

Fields date are in a database.

 

Then just format it? Should be possible to just do:

$diff = $datetime1->diff($datetime2)->format('Y');

Code (markup):

 

I use this. I guess it's the same.

$diff = $datetime1->diff($datetime2);
echo $diff->y

PHP:

 

With the DATEDIFF function, you are able to select what format you want to result returned in.
For example: DATEDIFF( datepart, start_date, end_date). You can replace the datepart variable with something like hour, day, week, year.