Total number of months (Count) between 2 dates

Question

I need to get total number of months in select query.

My table name is "Customers" and column name is "Createddate".

I need to calculate number of months between "Createddate" to current date.

Thanks in advance.

Answer 1

select datediff(month, createddate, getdate())
from customers