> 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(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice