title: oracle query between two dates with hours
body: <p>This is my current oracle table:</p>
  
  <ul>
  <li>DATE = date</li>
  <li>HOUR = number</li>
  <li>RUN_DURATION = number</li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/j6I8X.png" rel="noreferrer"><img src="https://i.stack.imgur.com/j6I8X.png" alt="enter image description here"></a></p>
  
  <p>I need a query to get RUN_DURATION between two dates <strong>with hours</strong> like</p>
  
  <p><code>Select * from Datatable where DATE BETWEEN to_date('myStartDate', 'dd/mm/yyyy hh24:mi:ss') + HOURS? and to_date('myEndDate', 'dd/mm/yyyy hh24:mi:ss') + HOURS?</code></p>
  
  <p><em>For example all data between 30.10.14 11:00:00 and 30.10.14 15:00:00</em></p>
  
  <p>I stuck to get the hours to the dates. I tried to add the hours into myStartDate but this will be ignored for the start date because of <code>BETWEEN</code>.
  I know <code>BETWEEN</code> shouldn't be used for dates but I can't try other opportunities because I don't know how to get <code>DATE</code> and <code>HOUR</code> together...
  Thanks!</p>