Using SQLLOAD to load string into valid date

Hi, everyone:

        I want to load a number of records from a file into a table, I know I can use SQLLOAD
to do it, however I am having troubles loading the second field(the one after the first comma),
I wonder if anyone has had to load a field like this one and would be kind to share that
information, thanks and take care.

RECORD:     ABCDEFGHI,1997-09-17-15.04.57.00 the second field : '1997-09-17-15.04.57.00'

needs to be loaded/parsed as a valid date format. Can I do it using SUBSTR in SQLLOADER or is there simpler way?

The table is t1 (id VARCHAR2(9), load_date DATE).

Thanks, Received on Mon Mar 30 1998 - 00:00:00 CEST