How to construct mysql query for converting months to years.

[eluser]shankar ganesh[/eluser]
Hello,

Please some one help me how to construct mysql query to convert no of months to years?, please refer the below content how the output should be.

Output should be,

if total months is 36 mnths then output should be 3years.

12mnths -> 1 year
15mnths -> 1 year
18mnths -> 1.5 year
20mnths -> 1.5 year
24mnths -> 2 year