Does anybody know anything about this?

"" <> wrote:

I get a "String to date conversion error" when I'm trying to do this:

update bla set blabla='6/21/2007'

despite having in the global prefs, data type controls, date, the "use default format (2007-06-22)" unchecked, and for "or locale-dependent format: Short (6/21/2007)" selected.

Am I doing something wrong?

I checked/unchecked the "allow inexact format on input", same result.
If I change my update to say '2007/06/21', I don't get the exception anymore.

This is the informix driver, 2.5, windows.

Thank you.

This email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
Squirrel-sql-users mailing list