> > The problem is the SQL code the doSelect() generates; how
> > does it format the passed in date? It could generate this:
> >
> > SELECT * FROM A WHERE D = '12-25-1999'
> >
> > but if the DB is configured to expect dates as DD-MM-YYYY,
> > the query will fail.
>
> Another solution would be to have the DB adapters provide methods
> formatting Java's Date object as expected for each RDBMS.
But that would not always work, because it also depends on the
client setup. For instance, with Oracle, the server may set a
date format like 'DD-MM-YYYY', and each client might modify
that date format to something else (including things such as
month names: JAN, FEB, etc., in any language supported by the
DB). You could probably argue that each instance of Turbine
could configure the date format separately, since each servlet
engine is really one "client" from the DB point of view, but I
still think using the documented JDBC escape syntax would be
a more generic solution:
SELECT * FROM A WHERE D = {d '1999-12-25'}
> Daniel
--
Gonzalo A. Diethelm
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
