mysql - 使用 SQL 从日期类型的生日字段中获取年龄

Question

我在 MySQL 数据库中有一个表，其字段类型为 date。这里存储了用户的生日。是否有纯 SQL 方法从字段中选择年龄？

Answer 1

像这样尝试...

SELECT
    id,
    Name,
    DateofBirth,
    ((DATEDIFF(Cast((Select Now()) as Date),
    Cast(DateofBirth as Date)))/365) AS DiffDate
from TABEL1

编辑考虑交易查理的事实....

 SELECT
        id,
        Name,
        DateofBirth,
        TIMESTAMPDIFF(Year, Cast(DateofBirth as Date),
        Cast((Select Now()) as Date)) AS DiffDate
    from TABEL1