Hi ! In a server with Conectiva Linux 6.0 (A Brazilian version) and Mysql 3.23.36 the comand "SELECT NOW()" returns "2003-07-05 10:00:00" both in the server and in the clients (Windows 98 with mysql-front and many programs writen in Delphi and MYODBC 2.50 or Zeos).
In a new server with Conectiva 8 and Mysql 4.0.13 the comand "SELECT NOW()" returns "2003-07-05 10:00:00" only on the server, but in the clients returns "05/07/2003 10:05:00" !! This format of date / time is the way we use here in Brazil, BUT the programs expect the other way (YYYY-MM-DD HH:MM) and then they crash ! :( What can I do / configure to get the same response on server and the clients ? Thanks Rubens Jr. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.496 / Virus Database: 295 - Release Date: 03/07/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]