Oracle sql loader from comma delimited file need to convert date from julian
Posted on 2008-09-29
I need to load the data into a date field where the file has the date in julian format of YDDD
I do not know how I need to code this in the sql loader file.
Example that does not work:
DATENMC "TO_CHAR(TO_DATE(:DATENMC, 'MM-DD-YYYY'), 'J')"
The data in DATENMC is a julian date of format YDDD. I want to load this into an Oracle table where the column is of data type DATE.