Uploading data with different date format

[DanAuber]

I have some flat file data that I want to upload (via sqlloade) into an Oracle table. The date in the flat file is in the format DD.MM.YY e.g. 23.09.01

How can I load this data into a date field in Oracle ??

thanks for any help

Dan

Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/

 

[MikeJones]

use a format mask i.e....

eftv_from DATE(8) "YYYYMMDD",

loads in the format YYYMMDD

you would want....

eftv_from DATE(8) "DD.MM.RR",

 

[DanAuber]

Thanks that's fine

Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/