mysql根据出生日期计算年龄

2015-4-23 Mysql koukou 3,877 views

4-23 3,877 views

SELECT *,DATE_FORMAT( FROM_DAYS( TO_DAYS( NOW( ) ) – TO_DAYS( birethday ) ) , ‘%Y’ ) +0 AS age FROM he_middle_bj

版权属于: KouKou

转载时必须以链接形式注明原始出处及本声明。