title: SQL To get count for a particular date range
body: <p>I want to count incomplete orders for particular date range</p>
  
  <p>My query:</p>
  
  <pre><code>select COUNT(ORDER_ID)
  from Atable
  where
    ORDER_TYPE='INCOMPLETE' and   
    DATE BETWEEN '31-OCT-14' AND '07-NOV-14'
  </code></pre>
  
  <p>But DATE column is <code>TimeStamp</code>.</p>
  
  <p>How can I use a wild-card and <code>between</code> together?</p>