title: Convert epoch with milliseconds into Date format in PL/SQL
body: <p>I have a column in my table (Data_type Number(16,0)) which stores the epoch time with milliseconds.</p>
  
  <p>Eg :- 1491456096759</p>
  
  <p>I want to write a select statement to format this into readable format which includes milliseconds 'YYYY-MM-DD HH24:MI:SS.FF'.</p>
  
  <p>Is there any direct functions that i can use for this conversion?? </p>
  
  <p>I have already tried this option</p>
  
  <blockquote>
    <p><code>select to_date('19700101', 'YYYYMMDD') + ( 1 / 24 / 60 / 60 / 1000) * 1491456096759
    from dual;</code></p>
  </blockquote>
  
  <p>But not able to print that date in 'YYYY-MM-DD HH24:MI:SS.FF' format</p>