Hi, Wakan wrote : > > Hi, > I've noticed this problem, even if I don't know if it's really a mysql problem: > if I store a date in standard format, in a date field, all kinds of > ordering are OK. > But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), > the order by clause attempt to order the new format incorrectly, because > I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!! > What can you say about this?
Nothing until you show us your query. I suspect that you are ordering by formatted date, which is a string, instead of date; but you don't give enough information to confirm that ! > Carlo > Regards -- Joseph Bueno NetClub/Trader.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php