Another ? on sql ldr- date format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Another ? on sql ldr- date format

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    I have a text file containing a date field. The date field appears in (YYYYMMDD format ex: '200010121'), however the field in the table is a date field.
    How can I convert this YYYYMMDD format to 'DD-MON-YY' format while loading into table using sqlldr.

    Help me ,

    Badrinath

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    DATE
    The data field contains character data that should be converted to an Oracle date using the specified date mask.
    For example:

    LOAD DATA
    INTO TABLE DATES (COL_A POSITION (1:15) DATE "DD-Mon-YYYY")
    BEGINDATA
    1-Jan-1991
    1-Apr-1991 28-Feb-1991

    See the documentation for rest of details.

    [url]http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/ch05.htm#20324[/url]


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