title: How to retrieve the records based on a date from oracle database
body: <p>I have a table with date column in it. I need to fetch the records from it based on 
  the given date.</p>
  
  <p>Currently when i used the query:</p>
  
  <pre><code>select * from workingemployee_data where created_date like '20-Jan-2012'
  </code></pre>
  
  <p>I am getting those records which have created_date on 20-Jan-2012</p>
  
  <p>But i want to get the records those were created 10 days earlier to a given 
  date (i.e) 20-Jan-2012.</p>
  
  <p>Please suggest me on this.</p>