oracle convert unix epoch time to date
<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>