Converting epoc for AutoSys reporting.

[AlHowarth]

I'm not sure if this is the right audience.  I'm pulling AutoSys data from an Oracle server.  Date fields are a pain as they are stored in an epoc.  To convert them to something useful, I found this code somewhere:

To_Char( To_Date( '01.01.1970 06:00:00','DD.MM.YYYY HH24:Mi:Ss')+ J.LAST_START / 86400,'MM/DD/YYYY HH24:Mi:ss') as LAST_START

The problem is the time is 11 hours ahead.  I changed the 06:00 to 00:00, which did reduce the time by 6 hours, but I can't figure out how to get the remaining 5.  Using a negative time has no affect ( '01.01.1970 -5:00:00'.

Does anyone know about this?

------------------------------
Engineer/DBA
Big Bank
------------------------------