待该州伙 发表于 2023-9-7 22:57:48

mysql根据出生日期计算年龄

SELECT *,DATE_FORMAT( FROM_DAYS( TO_DAYS( NOW( ) ) – TO_DAYS( birethday ) ) , ‘%Y’ ) +0 AS age FROM he_middle_bj
页: [1]
查看完整版本: mysql根据出生日期计算年龄