sql - How to get months duration between two dates in mysql?

Question

select  datediff (curdate(), hire_date )  as diff
from emp
order by hire_date asc; 

But, this does not give the output in months, how to get it in months?

question from:https://stackoverflow.com/questions/65872373/how-to-get-months-duration-between-two-dates-in-mysql

Answer 1

try something like: SELECT DATEDIFF(month, curdate(), hire_date) AS diff