OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
german datetime format?

From: Ralf Hüsing (ralfstormbind.net)
Date: Fri Oct 19 2007 - 20:40:30 CDT


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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql