SQL中你的年龄算对了吗？
时间：2011-06-03 来源：听风戏水
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 错误的年龄
相关阅读 更多 +
排行榜 更多 +
时间：2011-06-03 来源：听风戏水
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 错误的年龄
