-
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 ' ')
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|