title: Convert epoch to date in Oracle
body: <p>Was wondering if anyone could help with precision time conversion.
  Sample: 1501646399999 which is GMT: Wednesday, August 2, 2017 3:59:59.999 AM</p>
  
  <p>I used the below query, but it always rounds off to 02-AUG-17 04:00:00. Can anyone please guide me</p>
  
  <pre><code>select TO_TIMESTAMP('1970-01-01 00:00:00.000', 'YYYY-MM-DD hh24:mi:SS.FF3') + ((1/86400000) * 1501646399999)
  from dual;
  </code></pre>