Re: Date format on SQL*Loader import

Andy Kent wrote:
> I'm trying to import some data that's been exported from Access. The
> data contains dates like "2/11/2004", i.e. it's possible that the DD or
> the MM may not have both digits present. I'm using a date mask of
> "DD/MM/YYYY" but this seems to be causing SQL*Loader to barf. How do I
> tell it about the variation in the lengths?
>
> Or is a better way to do this?
>
> Thanks
>
> Andy

Post your control file and a sample record. It is impossible to know what you are doing from what you have posted.

PS: Oracle version number would be very helpful too.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)