title: Oracle date "Between" Query
body: <p>I am using oracle database. I want to execute one query to check the data between two dates.</p>
  <pre><code>NAME               START_DATE    
  -------------    ------------- 
  Small Widget       15-JAN-10 04.25.32.000000 PM      
  Product 1          17-JAN-10 04.31.32.000000 PM  
  
  
  
  select * from &lt;TABLENAME&gt; where start_date  
  BETWEEN '15-JAN-10' AND '17-JAN-10'
  </code></pre>
  <p>But I don't get any results from above query. I think I have to use &quot;like&quot; and &quot;%&quot;. But I don't know where to use them. Please throw some lights on this.</p>