DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert Epoch Date Time to Date Time format

833757Jan 27 2011 — edited Jan 28 2011

I am trying to convert Epoch Date time in GMT to Human Readable Date time format in UTC. I used the one below but it returns just the date in GMT but how can get datetime in UTC ?

select To_Char( To_Date( '01.01.1970 06:00:00','DD.MM.YYYY HH24:Mi:Ss') + STARTIME / 86400,'DD.MM.YYYY HH24:Mi:ss') FROM HQ_AVAIL_DATA_RLE;

I refered a couple of forums and applied everything, but still I wouldn't get the timestamp.

Please note that i'm looking for datetime stamp, not just the date.

Thanks in advance!

Edited by: 830754 on Jan 27, 2011 11:18 AM

Edited by: 830754 on Jan 27, 2011 11:19 AM