mysql 根据日期查询年龄

SELECT 
    user_id, 
    birth_date, 
    TIMESTAMPDIFF(YEAR, birth_date, CURDATE()) AS age
FROM 
    users;

SELECT 
    user_id, 
    birth_date, 
    TIMESTAMPDIFF(YEAR, birth_date, '2023-10-01') AS age
FROM 
    users;

SELECT 
    user_id, 
    birth_date, 
    TIMESTAMPDIFF(YEAR, birth_date, CURDATE()) AS age
FROM 
    users
WHERE 
    TIMESTAMPDIFF(YEAR, birth_date, CURDATE()) BETWEEN 20 AND 30;

SELECT 
    user_id, 
    birth_date, 
    TIMESTAMPDIFF(YEAR, STR_TO_DATE(birth_date, '%Y-%m-%d'), CURDATE()) AS age
FROM 
    users;

SELECT 
    user_id, 
    birth_date, 
    FLOOR(DATEDIFF(CURDATE(), birth_date) / 365.25) AS age
FROM 
    users;