Re: date format conversion

Lo

Translate the spaces into 0 characters using...

SELECT to_date(translate('98 610',' ','0'),'YYMMDD') from dual;

You can add the translate command to your control file to sort out the loader problem.

Cheers

Duncan

> SQL> SELECT to_date('98 610','YYMMDD') from dual;
> ERROR:
> ORA-01843: not a valid month
Received on Mon Nov 29 1999 - 13:40:17 CST