title: How to find the birth month
body: <p>Given the following data sample:</p>
  
  <pre><code>ID Dob
  
  001 01/10/1997
  002 09/02/1983
  003 19/10/1978
  ....
  </code></pre>
  
  <p>I tried a query like this:</p>
  
  <pre><code>select id, dob
    from table1
    where dob between '10/01/2012' and '10/31/2012'
  </code></pre>
  
  <p>But I am not retrieving any records. I want to display the id and dob matching with month.</p>
  
  <p>Expected output:</p>
  
  <pre><code>ID dob
  
  001 01/10/1997
  003 19/10/1978
  ....
  </code></pre>
  
  <p>I would like the output to match the month. </p>