如何将给定天数转换为MySQL中的年，月和日？

I am trying to get the date and time duration between the Loan taken and Paid date. I used the PHP date and time functions, but it is not always accurate. How can I do this accurately in MySQL?I am trying to get the date and time duration b