mysql> SELECT name, birth, curdate(),
-> (YEAR(curdate())-YEAR(birth))
-> - (RIGHT(curdate(),5) AS age
-> FROM pet ORDER BY name;
手册上说:“比较MM-DD值的表达式部分的值一般为1或0,如果curdate()的年比birth的年早,则年份应减去1。”
WHY?
[ 本帖最后由 zcm211 于 2009-2-16 18:58 编辑 ]
by
zcm211
-
MySQL
-
2009-02-16 18:57:20 阅读(1713) 回复(1)