Re: sysdate on sqlldr

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 7 Jan 2002 19:48:49 -0800
Message-ID: <44a19320.0201071948.610c33d3@posting.google.com>

gary, if you want load to a date field

in control file specify <column name > sysdate will do. ted chyn
"Gary Turner" <gary.turner_at_sci.com> wrote in message news:<x3o_7.147690$lV4.25433021_at_e420r-atl1.usenetserver.com>...
> 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 - 21:48:49 CST