Does anybody know anything about this?
"jan...@ya..." <jan...@ya...> wrote: 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
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|