|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Date sorting problem with Date_Format?
mikesz
qualityadvantages.com
Date: Fri Feb 08 2008 - 03:10:23 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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:mikeszqualityadvantages.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]