How to read a datetime field ?

From: Pedro <pedrofigueiredo_at_mail.telepac.pt>
Date: Tue, 06 Oct 1998 00:54:56 GMT
Message-ID: <361968cf.16247626_at_news.telepac.pt>

[Quoted] 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 Received on Tue Oct 06 1998 - 02:54:56 CEST