title: oracle convert unix epoch time to date
body: <p>The context is that there is an existing application in our product which generates and sends the EPOCH number to an existing oracle procedure &amp; vice versa. It works in that procedure using something like this </p>
  
  <pre><code>SELECT UTC_TO_DATE (1463533832) FROM DUAL
  SELECT date_to_utc(creation_date) FROM mytable
  </code></pre>
  
  <p>When I tried these queries it does work for me as well with Oracle 10g server (and oracle sql developer 4.x if that matters). </p>
  
  <p>In the existing procedure the requirement was to save the value as date itself (time component was irrelevant), however in the new requirement I have to convert unix EPOCH value to datetime (at the hours/mins/seconds level, or better in a specific format such as dd-MMM-yyyy hh:mm:ss) in an oracle query. Strangely I am unable to find any documentation around the UTC_TO_DATE and DATE_TO_UTC functions with Google. I have looked around at all different questions on stackoverflow, but most of them are specific to programming languages such as php, java etc. </p>
  
  <p>Bottom line, how to convert EPOCH to that level of time using these functions (or any other functions) in Oracle query? Additionally are those functions I am referring could be custom or specific somewhere, as I don't see any documentation or reference to this.</p>