add integer to datetime to find out date in vb.net

similiar question to the one asked before by someone, about age and date. I have 2 fields in sql server 2008 DOB = "01/05/1952" l开发者_JAVA技巧icence_age = 16 how do i get the year he go his licence from this information?

---

Assuming you already have DOB in a Date object named "myDate" and license_age in an Integer named "numYears", this will get you the license year:

myDate.AddYears(numYears).Year

Update Since you tagged this VB.NET, I assume you wanted a VB.NET answer. If you want to do this on the SQL side, then the other answer is correct.

---

To do this in the SQL query, checkout the DATEPART function. It and some trivial math should get you what you want.