gpt4 book ai didi

mysql - 如何从 MySQL Date 获取客户年龄

转载 作者:行者123 更新时间:2023-11-29 00:25:32 25 4
gpt4 key购买 nike

birthday
------------
1988-10-09
1919-12-12

如何正确计算年龄并四舍五入?

我有这个:

SELECT
ROUND((TO_DAYS(NOW()) - TO_DAYS(birthday)) / 365)
FROM customer

还有更准确的吗?

最佳答案

SELECT TIMESTAMPDIFF(YEAR, birthday, CURDATE()) AS age
FROM customer

Source

SQLFiddle demo

关于mysql - 如何从 MySQL Date 获取客户年龄,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/19110418/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com