Question: how to calculate difference between two dates in months in mysql?
Answer: SELECT DATEDIFF(DateOfService, BirthDate) / 30 as months FROM ... Returns the number of months between periods P1 and P2. P1 and P2 should be in the format YYMM or YYYYMM . Note that the period arguments P1 and P2 are not date values.