Re: [Squirrel-sql-users] String to date conversion error despite global prefs

[<jan...@ya...>]

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 <rob...@gm...> wrote: On 6/22/07, 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'

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