how to get number of days, month and year in mysql phpmyadmin4.7.9

#numberofdaysmysql, #monthsmysql
#years

with single statement get the difference between number of days,months and years using datediff(), timestampdiff()

[tonyjoseph]

WE CAN ALSO USE :
SELECT

EXTRACT(year FROM age(end_date, start_date)) AS YEARS,
EXTRACT(month FROM age(end_date, start_date)) AS MONTHS,
EXTRACT(day FROM age(end_date, start_date)) AS DAYS ;

[nishantm]

How to get months if we don't know end year?

[thechoosen]

Good job bro JESUS IS COMING SOON;PREPARE