Re: sysdate on sqlldr

From: Stan <stan0074_at_yahoo.com>
Date: Tue, 08 Jan 2002 05:46:25 GMT
Message-ID: <3C3A87F9.40201@yahoo.com>

Gary,

you can specify sysdate in controlfile and have them formatted with time component. here is an example of a controlfile to load data with datetime.

LOAD DATA
INFILE location_of_dat_file
INTO TABLE xyz

    (  rec_no                      "your_sequence.nextval",
       date_inserted         "to_char(SYSDATE, 'dd-mon-yyyy hh24:mi')",
       col1        POSITION(1:5)  "col1",
       col2        POSITION(6:15) "col2",
       data3        POSITION(16:22)"col3"

)

hth,
Stan

Gary Turner wrote:

> does anyone know how to get the date and time using the sysdate function on
> sqlldr. i can only get the date to be displayed. i have tried the on two
> different operating systems and see the same output.
>
>
>
>
Received on Mon Jan 07 2002 - 23:46:25 CST