- sqlserver数据库计算年龄
SELECT
birthday,
CASE
WHEN datediff(dd, dateadd(yy, datediff(yy, birthday, getdate()), birthday), getdate()) < 0 THEN datediff(yy, birthday, getdate()) - 1
ELSE datediff(yy, birthday, getdate())
END as age
FROM
tableName
- Mysql数据库
SELECT TIMESTAMPDIFF(YEAR,'2021-09-15',NOW());
- Oracle数据库
SELECT
TRUNC (
MONTHS_BETWEEN (SYSDATE, to_date('2020-09-15','YYYY-mm-dd')) / 12
) AS AGE FROM DUAL