title: Timestamp to number
body: <p>How to convert the CURRENT_TIMESTAMP function in a NUMBER using ORACLE?</p>
  
  <p>Using the following code, I'm able to extract the CURRENT_TIMESTAMP of the system</p>
  
  <pre><code>SELECT SYS_EXTRACT_UTC(CURRENT_TIMESTAMP) FROM DUAL;
  </code></pre>
  
  <p>What I want is to use the result of the above code to create the corresponding timestamp in unix format.
  Pratically:
  1) with SELECT SYS_EXTRACT_UTC(CURRENT_TIMESTAMP) FROM DUAL;
     i receive this result:</p>
  
  <pre><code>--------------------------------------------------
  |    SYS_EXTRACT_UTC(CURRENT_TIMESTAMP)          |
  --------------------------------------------------
  |       30-OTT-14 09:51:43,164232000             |
  --------------------------------------------------
  </code></pre>
  
  <p>2) And I want to convert it to:</p>
  
  <pre><code>--------------------------------------------------
  |               UNIXTIMESTAMP                    |
  --------------------------------------------------
  |                 1414662703                     |
  --------------------------------------------------
  </code></pre>
  
  <p>Is that possible?
  Thank you all in advance</p>