ASP.NET - year pass from current year

Asked By msakt on 24-Aug-12 02:01 AM
select CONVERT(VARCHAR,(rmd.DOB +'/2012'),102) AS Date


here 2012 is give as static,but i want year(getdate()) this value is pass in year
Danasegarane Arunachalam replied to msakt on 24-Aug-12 05:30 AM
Hope this helps

select CONVERT(VARCHAR,(rmd.DOB +'/'+ year(getdate()) ),102) AS Date