Hi,

can i change the datetime format on mysql in a german format?

At the moment the dates are stored like "2007-10-19 19:06:17" but if i
send a query (which comes from user input) the query looks like "WHERE
Datum >= '19.10.2007'" and i got not what i want.

iam using mysql (5.0.45) on (german) windows 2000,
clients are connected via ODBC-Driver (3.51.21.00) and the
application is using ADODB (mdac-lastest version).

thanks
Ralf

Ralf Hüsing wrote:
> Hi,
>
> can i change the datetime format on mysql in a german format?
>
> At the moment the dates are stored like "2007-10-19 19:06:17" but if i
> send a query (which comes from user input) the query looks like "WHERE
> Datum >= '19.10.2007'" and i got not what i want.
>
> iam using mysql (5.0.45) on (german) windows 2000,
> clients are connected via ODBC-Driver (3.51.21.00) and the
> application is using ADODB (mdac-lastest version).

Try converting the user input to the correct type with STR_TO_DATE(),
which despite its name can return a DATETIME value.

Baron