title: Difference between two timestamps (in days) in oracle including difference between timestamp
body: <p>I have a Table which has two fields with TimeStamp in Oracle DB. I have to calculate the difference between these two columns in Days including timestamp values.</p>
  
  <pre><code>Ex :- I have both column values as following than 
  Column1 value = 07-DEC-16 11.05.24.500000000 PM 
  Column2 value = 08-DEC-16 03.12.06.874000000 AM
  </code></pre>
  
  <p>Days Calculation should be shown as 1. Currently after doing search and reading many question on stackoverflow I came to know and now I am using following Query to calculate difference between these two columns</p>
  
  <pre><code>Select Extract( Day From Diff ) Days
  From (Select B1.Column2 - B1.Column1 As Diff
  From Table1 B1);
  </code></pre>
  
  <blockquote>
    <p>This query results in calculated Days as 0 instead of 1.</p>
  </blockquote>
  
  <p>I am not getting what to be done, please Guide through.
  Do I need to convert it to different format? or something else ?</p>