急，求助关于数据导出问题

Question

由于表内有时间戳格式非法字段（0001-01-01-00.00.00.000000），以至于数据导出时出现下列错误，
寻求帮助。

CWBDB0099 - No more data is available for the stream fetch request

SQL0181 - Value in date, time, or timestamp string not valid.

Cause . . . . . :   The string representation of a date, time or timestamp value is not in the acceptable range.  *N is either the character string constant that is not valid or the column or host variable that contained the string.  If the name is *N, then the value was found in an expression specified in the statement.  If the value was found in a host variable, then the host variable number is 44. The proper ranges for date, time, or timestamp values are as follows: -- The range for years is from 0001 to 9999. -- The range for months is from 1 to 12. -- The range for days is from 1 - 30 for April, June, September, and November, from 1 - 28 for February and from 1 to 31 for all other months.  In a leap year, the range for February can be from 1 to 29. -- The range for days in a Julian date is from 001 to 366 for a leap year or 001 to 365 days for all other years. -- The range for hours is from 0 to 24.  If the hour is 24, then the other parts of the time values must be zeros.  If the time format is USA, then the hour cannot be greater than 12. -- The range for minutes is from 0 to 59. -- The range for seconds is from 0 to 59. -- The range for microseconds is from 0 to 999999. Recovery  . . . :   Ensure that the date, time, or timestamp value conforms to the ranges for the data type it represents. Try the request again.

多谢各位！

Answer 1

上海道仑软件公司的跨平台数据库复制产品DBRoad可以解决这个问题。DBRoad可以实时或定时地将AS/400的数据同步到其它数据库如SQL SERVER,ORACLE中，供其它的应用使用，没有汉字和特殊字符问题。
如果有兴趣，可以联系我们：
http://www.taoroad.com/articles.aspx?id=DBRoad
xiongjm@taoroad.com
021-62786226-8008

Answer 2

数据移行可是一项浩大而繁琐的工程

Answer 3

将该字段转为想要的字符串格式再导出来应该没有问题