This query will do the trick:
SELECT TIMESTAMPDIFF(YEAR, created_at, CURDATE()) AS difference FROM my_table
Note: For differences in months, replace YEAR
with MONTH
, and for days replace YEAR
with DAY
This query will do the trick:
SELECT TIMESTAMPDIFF(YEAR, created_at, CURDATE()) AS difference FROM my_table
Note: For differences in months, replace YEAR
with MONTH
, and for days replace YEAR
with DAY