USING SQL LOAD TO LOAD A STRING INTO DATE FIELD

[Quoted] 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,

Thomas Morgan(tmorgan_at_mail.sdsu.edu) Received on Fri Apr 03 1998 - 00:00:00 CEST