-
Hi,
I've a date column in my table and I want to load data from a excel sheet into that table.How to specify that in control file.I studied something about date mask.But it's specified that if date mask is more than 11 characters length use the length field.What is it?
I've data in sheet like this.
date_field
1/2/2001 8:00
can I use like this ,or there is any other way
field_name DATE "dd/mm/yyyy , HH:MI"
Thanks,
kkr12
-
If you only wish to load the date and not the time, you could use "terminated by"
such as:
OPTIONS (ERRORS=1)
LOAD DATA
INFILE "e:\datain\data.txt "
APPEND INTO TABLE datain
fields terminated by ','
(a,
b,
c,
d,
mydate date "MM/DD/YYYY" terminated by ' ')