Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    21

    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.

    Thank you for all help in advance.

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    A true date field - or datetime?

    Have you tried:
    select * from mytable where tworkdt > date('05/05/2004')

    Also, check your version of setnet. A lot of ODBC errors go away with new releases.
    Fred Prose

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •