Re: How to read a datetime field ?

TO_DATE(C,'yymmdd hh:mi:ss') instead of the word date in the line.

HTH
  James

In article <361968cf.16247626_at_news.telepac.pt>, pedrofigueiredo_at_mail.telepac.pt (Pedro) wrote:

>I have this field 19981001 22:10:30 in a column of my data file , to
>be inserted in a table using sql*loader.
>How can I specify the format of the datetime field in the control file
>?
>
>LOAD into table XPTO
>FIELDS TERMINATED BY ';'
>( A char(10) ,
> B integer ,
> C date , <--- /* YYMMDD HH:MI:SS */ ?????
>)
>
>thank you in advance.
>
>pedrofigueiredo_at_mail.telepac.pt

-- 
lorenzen_at_yuck.net             | Life is complex; it has
                              |   real and imaginary parts