> I think you can try the SQL: > Select STR_TO_DATE([field_name], '%d/%m/%Y') as newDate , [field_name] from > [table] order by newDate asc; > > Thanks, > Haitao > > > -----Original Message----- > From: Vaibhav Informatics [mailto:[EMAIL PROTECTED] > Sent: 2008年3月13日 16:36 > To: php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] ordering date in varchar > > We have a problem. We have given the dates as date.month.year eg 27.12.2007 > The field is named as varchar. We have to arrange ths list of dates in > ascending order. Can anyone help? Varchar arranges the list by scanning from > left side. Perhaps scanning from right side will do. How to do it? > > For the best functionality and performance you should use date fields for your database.
-- Isaak Malik Web Developer [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
