Datatype mismatch ??

I have a PL-SQL script that has a statement like the following:

insert into bom_dummy_ref_desgs from
select * from bom_unique_ref_desgs

I get an error stating: Datatype mismatch on field UPDATE_DATE of type Date.

My ? is how could an invalid date value have been allowed on insert to the source table (I did not populate this table, I'm only querying it).

Is there a good solution to allowing the good records to go into the target table bypassing the invalid data value record in the source table?

Thanks,

zimmerman_fred_at_emc.com
fredz_at_silversoftware.com Received on Thu May 03 2001 - 19:56:20 CDT