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>


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

Original text of this message