Re: Corrupt Table
I suggest you run:
OUTPUT TO "corrupt.out"
SELECT ROWID, datecolumn
FROM tablename
ORDER BY 1
Once the script has crashed with the conversion error, look at the
last line of output to determine the last good ROWID read. Keep
adding 1 to the ROWID value and run the following until a row has
been updated:
UPDATE tablename
SET datecolumn = NULL
WHERE ROWID = value
Rerun the entire process until no errors occur. I hope you do not
lose too many date values!