Unanswered: ODBC Failed - [Informix]Date could not be converted to month/day/year format (#-1210)
We have a table with a column which called 'tworkdt' which is a date field.
When we try the following select statement from our application:
select * from mytable where tworkdt > '05/05/2004', we got the following error:
ODBC--called failed. [INTERSOLV][ODBC Informix driver]
[Informix]Date could not be converted to month/day/year format (#-1210)
Any ideas why we have this error?
When I looked at the table itself, I found there are some records that got corrupted (but the tworkdt field is not corrupted, it was other fields got corrupted). We have already deleted the corrupted data from the table but still got the above error.