DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sql loader and date type

  1. #1
    Join Date
    Feb 2001
    Posts
    34
    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

  2. #2
    Join Date
    Aug 2000
    Posts
    462
    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
  •  


Click Here to Expand Forum to Full Width