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

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)
use the Date format in your SQLLdr to match your input. like YYYY-MM-DD-HH24.MI.SS Received on Sat Apr 04 1998 - 00:00:00 CEST