title: Convert epoch to date in sqlplus / Oracle
body: <p>I have the following table:</p>
  
  <pre><code>SQL&gt; desc recording
   Name                 Null?    Type
   -------------------- -------- ------
   CAPTUREID            NOT NULL NUMBER(9)
   STARTDATE            NOT NULL DATE
   ENDDATE                       DATE
   STATE                         NUMBER(1)
   ESTIMATEDENDTIME              NUMBER(13)
  </code></pre>
  
  <p>Here's a single line for this table:</p>
  
  <pre><code>SQL&gt; select * from recording where CAPTUREID=14760457;
  
   CAPTUREID STARTDATE           ENDDATE             STATE ESTIMATEDENDTIME
  ---------- ------------------- ------------------- ----- ----------------
    14760457 29/09/2010 08:50:01 29/09/2010 09:52:04     0    1285746720000
  </code></pre>
  
  <p>I'm pretty sure that this has been asked so many times before, but all the solutions I've found so far didn't really work, so... How do I convert <code>ESTIMATEDENDTIME</code> from its original epoch form to a <code>DD/MM/YYY  HH:MI:SS</code> format in a single query in SQLPLUS?</p>
  
  <p>Thanks!</p>