String to date conversion error despite global prefs

Hi,

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 SF.net 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.
http://sourceforge.net/powerbar/db2/_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users