年龄转换成 **周(周岁)**月**日

select cast(datediff(mm,csdate+ '-01',getdate())/12 as varchar)+'年'
+cast(case when datepart(dd,getdate())>=datepart(dd,csdate+ '-01') then datediff(mm,csdate+ '-01',getdate())%12 else datediff(mm,csdate+ '-01',getdate())%12 -1 end as varchar)+'月'
+cast(case when datepart(dd,getdate())>=datepart(dd,csdate+ '-01') then datediff(dd,dateadd(mm,datediff(mm,csdate+ '-01',getdate()),csdate+ '-01'),getdate()) else datediff(dd,dateadd(mm,datediff(mm,csdate+ '-01',getdate()) -1,csdate+ '-01') ,getdate()) end as varchar)+'日' from tb_da_main where uid =432