Dates in sqlloader?
From: Colin Miller <c_miller_at_nospam-thank-you.bitwise.co.uk>
Date: Wed, 04 Oct 2000 17:01:56 +0100
Message-ID: <39DB5474.4C11C401_at_nospam-thank-you.bitwise.co.uk>
Date: Wed, 04 Oct 2000 17:01:56 +0100
Message-ID: <39DB5474.4C11C401_at_nospam-thank-you.bitwise.co.uk>
Hi all,
with SQLoader, is it possible to set the default date format for this
load, by using an
ALTER SESSION SET nls_date_format = '...'; type statement or other
method?
Also, is there a C-style UTC format (seconds since Midnight January 1st, 1970 GMT) to represent dates?
I'm using Oracle 7.3.4, with this style of control file
load data
infile data.csv
append
into table test_tab
fields terminated by ','
(
idx,
test_date,
test_date2,
);
I know I can specify the date format for each date field, but I want to avoid doing this.
TIA,
Colin Miller
Remove the obvious from below to reply.
c_miller_at_nospam-thank-you.bitwise.co.uk Received on Wed Oct 04 2000 - 18:01:56 CEST