How do I load data with sql loader with two date formats for one field?

I am loading bar delmited data with sql loader.  Some of the files used the date format MM/DD/YYYY and others use YYYY-MM-DD HH24:MI:SS.  The control file with MM/DD/YYYY format is listed below.  FIELD3 is the one with different formats.  Is there a way to use one control file to load files with the two different date formats?

LOAD DATA
INFILE 'sample.dat'
APPEND
INTO TABLE TMP_TABLE
FIELDS TERMINATED BY '|'
(FIELD1,
FIELD2,
FIELD3 DATE "MM/DD/YYYY",
FIELD4,
FIELD5 DATE "YYYY-MM-DD HH24:MI:SS")
wayneb01Asked:
Who is Participating?
 
awking00Connect With a Mentor Commented:
See attached.

format-dates.txt
0
 
awking00Commented:
Sorry, the control file should read date_check(...) and not check_date(...).
0
All Courses

From novice to tech pro — start learning today.