How to convert a UNIX timestamp to a date in Oracle

Sunday, 31 December 2006

Might come handy - How to convert a UNIX timestamp to a date in Oracle:

TO_DATE('19700101000000','YYYYMMDDHH24MISS')
+ NUMTODSINTERVAL(unix_epoch, 'SECOND')

Coolness.