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

[Robert M. <rob...@gm...>]

On 7/1/07, jan...@ya... <jan...@ya...> 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