title: How to return a birthday from an SQL statement, given a person's age
body: <p>I'm trying to create a filter in ASP.net, where a user can select a certain age and an SQL statement is to return all users who are currently this age, based on a 'DOB' (date of birth) field.</p>
  
  <p>So, for example, lets say that I have a variable <code>age</code> which currently holds 23. I've got a field in the database called 'DOB', of type 'date'. How would an SQL statement be written to return all records whose date of birth indicate that they are 23? The DOB format is in YYYY-MM-DD.</p>
  
  <p>Thanks</p>