title: how to augment precision of date difference in oracle
body: <p>I have to handle this ultraprecise date difference.</p>
  
  <p>In a stored procedure:</p>
  
  <pre><code>d1 := abs(q.date - p.date);
  -- renders .00001157407407407407407407407407407407407407
  
  d2 := abs(z.date - p.date);                  
  -- renders .00001157407407407407407407407407407407407407 (the same value assigned to d1)
  </code></pre>
  
  <p>But i know that d1 is slightly different from d2. Something in the likes of:</p>
  
  <p>real d1: .00001157407407407407407407407407407407407407001</p>
  
  <p>real d2: .00001157407407407407407407407407407407407407002</p>
  
  <p>Is there a way to augment oracle's numeric precision of d1 and d2?</p>
  
  <p>thanks.</p>