title: HOW TO FETCH DATA BETWEEN 2 DATES IN ORACLE SQL DEVELOPER
body: <p>I'm new to oracle sql . I want to fetch data between 2 dates .
  Date is in this format in db : <strong>13-DEC-10</strong></p>
  
  <p>This is the query I have written but its giving me error . How to proceed next </p>
  
  <pre><code>select sum(TOTAL_AMOUNT) from table a
  where trn_date between
  TO_DATE(01-APR-17, 'DD-MON-YYYY') AND TO_DATE(31-MAR-17, 'DD-MON-YYYY') ; 
  </code></pre>