Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*LOADER: converting ulong date-time to oracle format
select encode(*) from sys
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 - 13:20:45 CDT