|
From: <jan...@ya...> - 2007-07-02 01:26:57
|
Yes, I tried {d 'yyyy-mm-dd'}, it doesn't work. Even it would work, I'm not interested in yyyy-mm-dd, but in mm/dd/yyyy...
Thanks
Robert Manning <rob...@gm...> wrote: On 7/1/07, 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
|
