select convert(date,format(Getdate(),'yyyy')+'/'+format(Birthdate,'MM')+'/'+format(Birthdate,'dd')) from Employee
Result:
0 Comments