-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|