You can treat it with DATE_FORMAT() and TIME_FORMAT(), change the format of MySQL variable, don't have way. You have to make a explicity convertion.
;-) Wagner Bianchi Diretor de Tecnologia - INFODBA Technologies & Consulting [EMAIL PROTECTED] - (31) 3272 - 0226 / 8427 - 8803 ----- Mensagem original ---- De: Baron Schwartz <[EMAIL PROTECTED]> Para: Ralf Hüsing <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Enviadas: Sexta-feira, 19 de Outubro de 2007 22:56:02 Assunto: Re: german datetime format? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/