Re: date mask in SQL*Loader

web guy wrote:
> I'm using SQL*Loader with a delimited file from Excel. I have a date
> field that the users are 'supposed' to populate with a format of
> 'mmddyyyy', and I simply do a to_date(:date_field,'MMDDRRRR') in the lod
> script and all is well.
>
> However, very often I get dates in the file with a format of 'M/D/YYYY'
> or 'MM/DD/YYYY', and rather then reject that record during load, I would
> of course like to load it anyway.
>
> Any suggestions on how to do this?
>
> Tim

Define a discard file and send those records back to be fixing.

Covering for other people's inadequacies is a recipe for working evenings and weekends. And no one will remember you did it three weeks later except to expect you to do it yet again.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org