Re: String to date conversion error despite global prefs

On 7/1/07, janekindred@xxxxxxxxx <janekindred@xxxxxxxxx> wrote:
> 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?

The JDBC API supports an escape syntax that the driver can translate
and it looks like:

{d 'yyyy-mm-dd'}

which the driver is supposed to translate into the appropriate format
for the database.  Have you tried that?

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/