您好，可以使用datediff()函数，demo示例如下，
mysql> create table dd(d1 date,d2 date);
Query OK, 0 rows affected (0.10 sec)
mysql> insert into dd values(‘1998-01-01’,‘2020-01-01’);
Query OK, 1 row affected (0.02 sec)

mysql> select * from dd;
±-----------±-----------+
| d1 | d2 |
±-----------±-----------+
| 1998-01-01 | 2020-01-01 |
±-----------±-----------+
1 row in set (0.00 sec)
mysql> select round(datediff(d2,d1)/365) from dd;
±---------------------------+
| round(datediff(d2,d1)/365) |
±---------------------------+
| 22 |
±---------------------------+
1 row in set (0.00 sec)