title: How to get only date/month part from a date in postgres SQL
body: <p><strong>Hello All</strong>
  I have a table in my pg admin database.There is an <strong>employee</strong> table in this table.Having the field:-
  1)name
  2)date_of_birth</p>
  
  <p>Now the scenario is that I want to know the birth day for current date and upcoming 20 days 
  For example if current date is 28-Jan-2013 then</p>
  
  <pre><code>1)from_date=28-Jan-2013
  2)to_date=16-feb-2013
  </code></pre>
  
  <p>I want to select  all the records from the table for which the 
   <strong>date_of_birth</strong> </p>
  
  <pre><code>lies between 28-Jan and 16-feb
  </code></pre>