> You should correct those values in v1.5 before upgrading to v2.x.
I did find an different way:
It is possible to wipe out defective data within FB2.5:
UPDATE t SET f=null WHERE EXTRACT(year FROM f)<1859
Using EXTRACT does also allow to read defective data to let you see what
is going wrong - perhaps entries with an large year have to be deleted too.
Elmar
------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
