title: SQL query to fetch records within a time range for particular date range/period
body: <p>Looking for a SQL query to fetch TABLE records within a time range for a particular date period. </p>
  
  <p>For example, 
  How to write query, if I need to fetch records from a table <code>TABLE1</code> where </p>
  
  <p><code>DATE_COLUMN &gt;= 2019-04-01 AND DATE_COLUMN &lt; 2019-04-10</code> </p>
  
  <p>and also Time of these selected records should be within <code>12:00</code> to <code>13:00</code></p>
  
  <p><em>Note : Datatype of <code>TABLE1.DATE_COLUMN</code> is <code>DATE</code> which also holds time part</em></p>
  
  <p>Please help</p>