Hello mysql list, As is very often the case, five minutes after I posted this, I found the problem or solution, not sure it was the "problem" as I am not convinced that mysql ought to get confused so easily. I changed
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date, DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS FmtDate, and used the FmtDate reference to display the query results and it worked fine. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
