Oracle - generating date from (days from Jan 1) in SQL LOADER
Posted on 2013-06-21
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?