title: The difference between two dates in the same column in oracle in days/Hours/minutes
body: <p>I am looking to calculate the difference between two dates in days/hours/minutes.</p>
  
  <p>I have a table with the following data structure:</p>
  
  <pre><code> ID                   Date                           Location          Type
  ---------------------------------------------------------------------------------
  42ABC          15-NOV-14 12.45.00 PM                    YY            Departed 
  42ABC          15-NOV-14 03.10.00 PM                    AA            Arrived
  42ABC          18-NOV-14 05.15.00 PM                    AA            Departed
  42ABC          18-NOV-14 07.20.00 PM                    YY            Arrived
  </code></pre>
  
  <p>How do i calculate the difference in dates, and get something like this: </p>
  
  <pre><code>ID                Location                   DURATION
  -----------------------------------------------------------------
  42ABC               AA                 3 days, 2 hours, 5 minutes 
  </code></pre>
  
  <p>I appreciate your input in this.</p>