mysql How can i get date difference result in such a formate year:month:day

Question

i want to get date difference.

i am using this query:- SELECT DATEDIFF('2012-08-01', '1978-12-06') AS intval ;

but this is returning only number of days. but i want result such like this:-

result:- 33year,2month,12days

please suggest me how can i write such type of query.

score 1 · Accepted Answer · edited May 23 '17 at 10:08

1

Here is a calculator for date difference

Please refer thie link

this is a stackoverflow link

edited May 23 '17 at 10:08

Community

answered Dec 14 '11 at 12:10

Pradeep Singh

Thank you pradeep, but can you provide me sql query for this.? – Pushpendra Kuntal Dec 14 '11 at 12:48
http://stackoverflow.com/questions/57599/how-to-calculate-age-in-t-sql-with-years-months-and-days – Pradeep Singh Dec 14 '11 at 12:56
hey, you have provide some wrong information. The calculator does not required mysql to generate the differences. **Most importantly, It does not generate accordingly to the format** – ajreal Dec 14 '11 at 12:58

1 Answers1