Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> date mask in SQL*Loader
I'm using SQL*Loader with a delimited file from Excel. I have a date
field that the users are 'supposed' to populate with a format of
'mmddyyyy', and I simply do a to_date(:date_field,'MMDDRRRR') in the lod
script and all is well.
However, very often I get dates in the file with a format of 'M/D/YYYY' or 'MM/DD/YYYY', and rather then reject that record during load, I would of course like to load it anyway.
Any suggestions on how to do this?
Tim Received on Fri Feb 09 2007 - 10:17:33 CST
![]() |
![]() |