Re: USING SQL LOAD TO LOAD A STRING INTO DATE FIELD

I believe that you want the column definition to read...

    load_date date "to_date(:load_date,'YYYY-MM-DD-HH24.MI.SS.00') "

Mike Krolewski

Thomas Morgan wrote:

> 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 Tue Apr 14 1998 - 00:00:00 CEST