title: oracle sql date format to only seconds
body: <p>So I'm trying to convet a timestamp to seconds.</p>
  
  <p>I read that you could do it this way</p>
  
  <pre><code>to_char(to_date(10000,'sssss'),'hh24:mi:ss')
  </code></pre>
  
  <p>But turns out this way you can't go over 86399 seconds. </p>
  
  <p>This is my date format: +000000000 00:00:00.000000</p>
  
  <p>What's the best approach to converting this to seconds? (this is the result of subtracting two dates to find the difference).</p>