case isDate(birthYm) when 0 then0 elsedatediff(year,birthYm,getDate()) endage,
case
isDate(birthYm)
when
0
then
else
datediff(
year
,birthYm,getDate())
end
age,
isDate()函数,布布扣,bubuko.com
isDate()函数
原文:http://www.cnblogs.com/kevin1988/p/3597015.html