SELECT FLOOR(DATEDIFF(day,'1987-06-07', GETDATE())/365.24219) AS 实岁
,DATEDIFF(YEAR,'1987-06-07',GETDATE())+1 AS 虚岁
,DATEDIFF(YEAR,'1987-06-07',GETDATE()) AS 错误的年龄
 posted on 2011-06-03 17:15  听风戏水  阅读(185)  评论(0)    收藏  举报