Oracle - generating date from (days from Jan 1) in SQL LOADER
We are using SQL Loader to take data from a text file into an Oracle table as we have done many times before.
The date format in the text file is 05150 - two digit year followed by the days since Jan 1 of that year. We need to convert that into a standard date AND assume that anything < 60 is 1900 + two digit year.
Is there a way to do this in SQL LOADER?
Or, is there a way to call an external DLL or EXE from SQL Loader?
The date format in the text file is 05150 - two digit year followed by the days since Jan 1 of that year. We need to convert that into a standard date AND assume that anything < 60 is 1900 + two digit year.
Is there a way to do this in SQL LOADER?
Or, is there a way to call an external DLL or EXE from SQL Loader?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
awking00
So you would expect 05150 to be 30-MAY-1905?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It would be the opposite of RR I believe.
If it's greater than 50 it would be 1900 and if it's less than 50 it would be 2000
If it's greater than 50 it would be 1900 and if it's less than 50 it would be 2000
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent - Thanks!
Sorry for having mistyped, but you got it figured out :-)