> Bad dates like 02/31/2006 will be converted to sane dates. Actually, that's the core of the direct query! select * from foo where to_date(olddate,'YYYY-MM-DD')::text <> olddate; The format of the exported dates matches the default date::text format because I specified the export that way. If not, the query would be a little more complicated by having to specify the format, but the same basic idea still would work. Which is good, since I'm now on to a table that has 108 bogus dates. I'd hate to find & fix them one at a time... -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice
