|
From: Robert M. <rob...@gm...> - 2007-07-02 00:53:13
|
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
|
