Re: SQL*LOADER: converting ulong date-time to oracle format

select encode(*) from sys
[Quoted] [Quoted] 21,'Responder',26593,924751530,924755728,1,0,119,4,15,0,0,0,0

In the above example, column 4 and 5 are the date/time stamps. They are standard Universal date time, when decoded with our proprietary function they look like:

select date(sys_updated) from sys
Wed, 21 Apr 1999 21:35:28 PDT

Unfortunately, I can't use this date function, I need to directly translate from ulong to ORACLE date.

Any help appreciated.

Regards.
fk Received on Mon May 10 1999 - 20:20:45 CEST