Re: String to date conversion error despite global prefs

On 6/22/07, janekindred@xxxxxxxxx <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/