DATE PROBLEM

[scotta]

Hi,
I am having trouble using SQL Loader.
Whenever it encounters a date that has 2000 as a year
it will not load this entire record.
It gives me an "Not a valid month" error.
I am using Oracle 7.3.4

i.e. "10/27/2000"

all other records are loaded

i.e. "10/13/1999
Is there something I need to include in the control file
to get pass this error

Any help would be greatly apperciated

--scotta

[marist89]

There is a way to explictly specify your date format in the control file. After you specify that the column will be a date, include "mm/dd/yyyy". For example:

load data
infile *
append
into table xxx
fields terminated by ","
(my_date date "mm/dd/yyyy")

[dba_sys]

Hi,

Just see the csv file and decide the date format to use (ie mm/dd/yy or mm/dd/yyyy ) for date values.

-Anand