出生年月是字符串型,格式为1970-1
------解决方案--------------------
declare @x varchar(10)
select @x='2012-2'
select rtrim(datediff(m,@x+'-01',getdate())/12)+'岁'
+rtrim(datediff(m,@x+'-01',getdate())%12)+'月' 'age'
/*
age
----------------------------
2岁3月
(1 row(s) affected)
*/
------解决方案--------------------
declare @brithdate varchar(20)
set @brithdate='1970-1'
select datediff(yy,@brithdate+'-01',getdate())
/*
44
*/