MySQL-学习笔记:根据生日获得年龄 TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2) unit:返回的单位,year、month、day、hour、minute、second datetime_expr1:表中生日字段名 datetime_expr2:now() 函数返回的是expr2-expr1的差值 SELECT userName,TIMESTAMPDIFF(YEAR,userBirthday,NOW()) as age from userinfo;