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_STARTThe 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
------------------------------