SQL*Loader and date/time datatypes

Subject: SQL*Loader and date/time datatypes

We are trying to extract data from an old DB2/2 database to load into an Oracle 8.1.7 database. DB2/2 has separate data types for date and time. So, given the original table that looks something like this:

CREATE TABLE MY_TEST
(MY_DATE DATE,

      MY_TIME TIME) We would create this table in Oracle:

CREATE TABLE MY_TEST
(MY_DATE DATE,

      MY_TIME DATE) The extracted data file looks like this:

20010624,"13.36.23"

We have no trouble loading MY_DATE with no time component (running a test with no "time" data), but cannot get MY_TIME loaded. We would prefer to have no date component at all, but would be willing to use a default of either a fixed "magic" date or sysdate, but can't seem to work out the syntax for the SQLLoader control file to make this happen.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)