Robert,
thanks for the response.
I tried to use the "date" function using a MM/DD/YYYY format:
date('02/02/2002')
but I get the same error.
Now the thing is, if I use a non-java based client, like winsql (which is not that great compared to squirrel) for example, all's fine, although I have no setting that tells winsql how to treat a date literal. So I don't think the problem lies with the database configuration itself, but with jdbc, because some Java apps I've written in Java also default the date literal to 'yyyy/mm/dd'. Is there a way to change this thru squirrel?
Thanks.
Robert Manning <robert.m.manning@xxxxxxxxx> wrote:
On 6/22/07, janekindred@xxxxxxxxx wrote:
> Hi,
>
> I get a "String to date conversion error" when I'm trying to do
this:
>
> update bla set blabla='6/21/2007'
It looks like the database is performing an implicit conversion (you
gave it a string and the column is a date - it needs to reconcile that
somehow). I'm guessing here as I have little knowledge of Informix.
Generally, date types can be obtained by using a date function on a
string that has a date format that the date function can understand.
I suppose the first format you chose was not what the implicit
conversion was expecting. You should consult your Informix product
manual for guidance on what the format of date strings can be and if
there are date functions that can/should be used.
The date datatype format choices in SQuirreL apply to how dates are
displayed and edited. So, any SQL with date strings that you execute
goes to the database as is.
Rob
-------------------------------------------------------------------------
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
| 
