Printable View
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.
http://otn.oracle.com/docs/products/...ch05.htm#20324